When connecting from a command line, mysql uses 3 of the columns in the user table to decide whether or not to grant access. These are host, user, and password. Note that in your results below, there is no localhost-newsletter-testPass combination. What the table shows is that clients from any host other than localhost can log in to a mysql client using the newsletter and testPass combination.
If you want to login using a client on the same machine that you're running mysql, you need to add another entry to the user table, i.e., GRANT ALL PRIVILIGES ON newsletter.* TO newsletter@localhost IDENTIFIED BY 'testPass' It took me a while to figure that one out, but it's saved me a lot of frustration knowing it now. I guess I don't understand why localhost isn't included in the % wildcard for the host column in this table. Anybody? John Arnold Director, IT Web Strategies 2k3 Technologies 915.439.1660 -----Original Message----- From: Neil Aggarwal [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 11:00 AM To: Mysql list Subject: Password problem Hello: As the root user, I created a new database and user account: CREATE DATABASE newsletter; GRANT ALL PRIVILEGES ON newsletter.* TO newsletter IDENTIFIED BY 'testPass'; FLUSH PRIVILEGES; I then tried to access the databse via the command-line client: /usr/local/mysql/bin/mysql -u newsletter -ptestPass newsletter And I get this error: ERROR 1045: Access denied for user: 'newsletter@localhost' (Using password: YES) I checked that mysql has it set-up correctly in the user and db tables by logging in as the root account. select * from user give me this line: | % | newsletter | 61fa73f50740c213 | N | N | N | N | N | N | N | N | N | N | N | N | N | N select * from db gives me this line: | % | newsletter | newsletter | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Any ideas? Thanks, Neil. -- Neil Aggarwal JAMM Consulting, Inc. (972) 612-6056, http://www.JAMMConsulting.com Custom Internet Development Websites, Ecommerce, Java, databases --------------------------------------------------------------------- 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
