> you can do this:
>
> mysql> set password for newsletter@localhost=PASSWORD("testPass");
>
> or
>
> mysql> update user Set Password=Password("testPass")
> -> where user="newsletter";
Don't forget the "flush privileges" thing after the update command.
> __
>/ \\ @ ____
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
