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
Thanks,
Chris
PS It's built from source:
mysql> status
--------------
mysql Ver 11.15 Distrib 3.23.38, for pc-linux-gnu (i686)
Connection id: 15
Current database:
Current user: mysql@localhost
Current pager: stdout
Using outfile: ''
Server version: 3.23.38
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 2 hours 51 min 20 sec
---------------------------------------------------------------------
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
