List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 19 2002 8:31pm
Subject:Re: GRANT questions on OS X.
View as plain text  
At 14:58 -0400 4/19/02, Barry C. Hawkins wrote:
>Alex,
>      Enclose the user string in quotes.  This will allow you to use 
>the global wildcard option.
>
>Example:
>GRANT ALL ON *.* TO "myuser@%" IDENTIFIED BY "mypassword";

You should quote the user name and host name parts separately.

"myuser"@"%"

>
>      For those not using Mac OS X, the default shell is tcsh.  I am 
>not sure if this quirk is a function of string handling in tcsh or 
>what, but this is the workaround I am using.

The shell doesn't have anything to do with how MySQL interprets the
GRANT statement.

??

>
>Happy granting,
>--
>Barry C. Hawkins
>Systems Consultant
>All Things Computed
>barry.hawkins@stripped
>
>
>
>On Fri, 19 Apr 2002 13:45:56 -0400 Alex Pilson 
><alex@stripped> wrote:
>
>Why is this producing a syntax error at the %? This is supposed to
>create a global user, yes?
>
>GRANT ALL ON *.* TO myuser@% IDENTIFIED BY "mypassword";
>
>Is there a quick command to show all GRANTS? or Users?
>--

Thread
Max 127 recordsHenning Olsen19 Apr
  • SV: Max 127 recordsCarsten Gehling19 Apr
  • Re: Max 127 recordsFred van Engen19 Apr
  • Re: Max 127 recordsSteve Buehler19 Apr
  • Re: Max 127 recordsCiprian Trofin19 Apr
  • RE: Max 127 recordsRoger Baklund19 Apr
  • Re: Max 127 recordsEgor Egorov19 Apr
  • Re: Max 127 recordsRichard Emery19 Apr
  • licenceKlym19 Apr
    • Re: licenceSinisa Milivojevic19 Apr
      • Re: licenceIko Rein21 Apr
  • Re: licenceNeil Highley19 Apr
    • Re: licenceSinisa Milivojevic19 Apr
      • Re: licenceShaun Bramley19 Apr
        • GRANT questions on OS X.Alex Pilson19 Apr
          • Table Locks...Sukhdev Sethi20 Apr
            • Re: Table Locks...Gelu21 Apr
Re: GRANT questions on OS X.Alex Pilson19 Apr
  • query optimizationSteve Katen19 Apr
  • Re: GRANT questions on OS X.Paul DuBois19 Apr
Re: GRANT questions on OS X.Barry C. Hawkins19 Apr
Re: GRANT questions on OS X.Paul DuBois19 Apr