List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:June 2 2001 2:50am
Subject:Re: FW: ezmlm response
View as plain text  
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
FW: ezmlm responsedaddius2 Jun
  • Re: FW: ezmlm responsePaul DuBois2 Jun
    • Re: FW: ezmlm responseZachary Burnham3 Jun
      • Re: FW: ezmlm responsePaul DuBois3 Jun
  • Re: ezmlm responseRohit Peyyeti2 Jun