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.
"myuse
>>>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";
>>
>>myuser@"%"
>
>Andrew Hazen emailed me to use single quotes and it worked. So does
>mysql care if it is single or double quotes?
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";
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
At 12:59 PM -0500 4/19/02, Paul DuBois 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";
>
>myuser@"%"
Andrew Hazen emailed me to use single quotes and it worked. So does
mysql c
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?
--
<->
Alex Pilson
FlagShip In
