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, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
