may need to double quote the % sign.
trav
On Thu, 5 Jul 2001, 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
>
> 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
