mysql authentication error

[Anon]

Hi,

Newbie question.

Trying to connect to the mysql running on the same box as my php parser. I have entered:
Host: localhost
User: user1
Password: password1
into the 'user' table of the 'mysql' database. I have also set all the privilege entries to 'Y';

I then did ./mysqladmin reload

I am using this PHP code:
$connection=mysql_connect("localhost","user1","password1") or die("could not connect to mysql");

I get this error back:
Warning: Access denied for user: 'user1@localhost' (Using password: YES) in /var/www/html/admin/test.phtml on line 10

could not connect to mysql

Thanks for your help!

[cornelalexa]

you must use this when you set the privileges for the user1
grant all privileges to * from 'user1'@'localhost'

else the the host where the user is conecting will not be set.
If you want to give acces from any host just use '%' instead of localhost.

Hope to help.

[Anon]

I was using a plain text password in the user table instead of using PASSWORD('password1'); to generate the hash.

Thanks all