In the last episode (Jun 10), Kaan Oglakci said:
> Hi,
> For some reason when I try to set up grants for a database by typing this
> GRANT ALL ON newstesting.* to clients@% IDENTIFIED BY 'pass';
>
> I get this error
> ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED BY
> 'pass'' a
> t line 1
Try quoting the %: '%'
In fact, to be safe, I always quote the username and the hostname:
'clients'@'%'
--
Dan Nelson
[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
