Devin Miller wrote:
>
> I am pretty new to mysql and have been teaching myself slowly how to use
it.
> I am however stuck on a problem. I login to mysql as user root and created
a
> database named devin. I then issue the following commands:
>
> GRANT ALL PRIVILEGES
> ON devin.*
> TO dmiller@"%"
> IDENTIFIED BY "password";
>

Try this....

GRANT ALL PRIVILEGES
ON devin.*
TO 'dmiller'@'%'
IDENTIFIED BY 'password';

This worked for me... notice the quote around the username.

--
Thomas


---------------------------------------------------------------------
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

Reply via email to