MySQL - Access denied for user

[dustbuster]

Hello all,

I'm running MySQL and PHP on a Windows 2000 server. I have a script that connects to a database but I continually get this error:

Access denied for user: 'myuser@localhost' (Using password: YES)

I connect with this:

$connection=mysql_connect("localhost","myuser","userpass");
mysql_select_db("mydb",$connection);

I had first been testing with no username or password.
Since I have access to the database I decided to password protect it.

I entered the following commands at the mysql> prompt:

mysql> USE mysql;
mysql> INSERT INTO user (Host, User, Password, Select_priv) VALUES ('', 'myuser', password('userpass'), 'Y');
mysql> GRANT ALL ON mydb.* TO myuser;
mysql> FLUSH privileges;
mysql> quit

When I try to connect to the database throught the mysql consol with
mysql -D mydb -u myuser -p userpass

I get the error message: Access denied.

I can access the database as root with the script and the console but nothing else.

Any help would be great.

Thanks

[jerdo]

You might try getting phpMyAdmin from http://www.phpmyadmin.net it will make your life a little easier.

[dustbuster]

I installed phpMyAdmin but I still get the error with the user name and password. I can't figure out why I can use the root password to access the db but not the user I set up for that database.

[jerdo]

My suggestion was more meant to use phpMyAdmin to remove the errant user, use the Reload Mysql link in phpMyAdmin, put the user back in and use the Reload Mysql link again. Since your root works fine you should be able to do that, it's possible the user isn't getting the correct permissions for that db and setting that user up in phpMyAdmin is much easier than using the command line.