At 15:03 -0500 1/27/03, 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";
The command returns a Query ok and 0 rows affected. However, when I try to
login with dmiller (mysql -u dmiller -p) I get a 1045 Access denied error. I
have triple checked spelling and such and it looks good as far as I know.
Any Ideas? Thanks a lot in advance for your help. Btw I am using MySQL ver.
3..23.52.
Do you have the anonymous users in your user table that are created
during the initial installation? (The ones with blank User column values.)
If so, delete them, FLUSH PRIVILEGES, and try again.
(Assuming you don't need the anonymous users, which you don't.)
Devin Miller
No electrons were hurt in the making of this email.
---------------------------------------------------------------------
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
