Devin, > 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.
With "mysql -u dmiller -p", the hostname will be "localhost" (the default). Obviously, there is an entry in the privilege table mysql.user which takes precedence over '%'. You have two ways to solve this problem: 1) GRANT ALL ON devin.* TO 'dmiller'@'localhost' IDENTIFIED BY 'password'; 2) mysql -h machine_name -u dmiller -p In case #2, you have to substitute <machine_name> by the name of the machine you are connecting from. Don't use 'localhost', though ;-) If you're curious as to why and how: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database _Administration.html#Connection_access Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- 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? Thanks a lot in advance for your help. Btw I am using MySQL ver. > 3..23.52. > > 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 > --------------------------------------------------------------------- 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