At 4:39 PM -0400 6/3/01, Zachary Burnham wrote:
>Is this new syntax? It seems to be different from your book, Paul.
Yes, the quoting rules changed a little subsequent to publication of
the book. The safest way to specify the account name is to quote both
the user and host parts, but you must quote them separately: "user"@"host"
>
>Z
>On Friday, June 1, 2001, at 10:50 PM, Paul DuBois wrote:
>
>>At 10:13 PM -0400 6/1/01, daddius wrote:
>>>hello everyone... I am very new to mysql and I needed some help creating 1
>>>admin account for 4 computers.
>>>This is the error I keep getting.
>>>
>>> mysql> grant all on *.* to admin@% identified by "password";
>>> ERROR 1064: You have an error in your SQL syntax near '% identified by
>>>"password"' at line 1
>>> mysql>
>>
>>Put quotes around the % character:
>>
>>mysql> grant all on *.* to admin@"%" identified by "password";
>>
>>-- Paul DuBois, paul@stripped--
Paul DuBois, paul@stripped

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.