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
>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.
Paul DuBois, paul@stripped