it looks as though you have created the newsletter user with plain text password. mysql will compare the user password against the encrypted password and will fail.
you can do this: mysql> set password for newsletter@localhost=PASSWORD("testPass"); or mysql> update user Set Password=Password("testPass") -> where user="newsletter"; Also see page 393 of the "mysql Reference Manual" thanks Nasser. ============================================= >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? Yes. See Chapter 4.3.5 of the mysql manual. "Note that we must issue GRANT statements for both monty@localhost and monty@"%". hth, Doug > >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