Assuming you logging in from the same server on which mysqld is running, you need a dmiller@localhost user. The "%" wildcard is valid only for tcp connections. This is thoroughly explained in the MySQL manual, chapter 4.3.5.
hth, Doug On Mon, 27 Jan 2003 15:03:35 -0500, 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. > >Devin Miller > --------------------------------------------------------------------- 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