Re: GRANT questions on OS X.

[Paul DuBois]

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?
>--