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
