List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 6 2001 3:40am
Subject:Re: Mysql question (access rights)
View as plain text  
At 9:20 PM -0600 7/5/01, Chris M wrote:
>I've got a question.
>
>In the otherwise-excellent Paul DuBois book, on page 427 or so it talks
>about how you can do this:
>
>GRANT SELECT ON menagerie.* TO ro_user@% IDENTIFIED BY "dirt";
>
>So I tried something similar:
>
>mysql> GRANT SELECT ON *.* TO mysql@% IDENTIFIED BY "dirt";
>ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED BY
>"dirt"' at line 1
>
>Well that sucks!
>
>I also tried %.mydomain.com also and the specific FQDN of a host all with
>similar errors.
>
>So what's up with that? The only time it works is when I use mysql@localhost

The quoting rules changed a bit after publication of the book.  Try putting
quotes around the hostname part: mysql@'%', mysql@'%.mydomain.com', etc.

>
>Thanks,
>Chris


-- 
Paul DuBois, paul@stripped
Thread
got nowhere faster :(trogers6 Jul
  • Mysql question (access rights)Chris M6 Jul
    • Re: Mysql question (access rights)Paul DuBois6 Jul
    • Re: Mysql question (access rights)T LaWall6 Jul
  • Re: got nowhere faster :(Duncan Hill6 Jul