----- Original Message -----
From: "Devin Miller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 27, 2003 9:03 PM
Subject: Adding a user problem
> 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?
Yes. :) Do as the manual tells you: after you created the user, do,
FLUSH PRIVILEGES;
And you'll be ok.
- Mark
System Administrator Asarian-host.org
---
"If you were supposed to understand it,
we wouldn't call it code." - FedEx
---------------------------------------------------------------------
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
