Mysql grant problem

[lecter]

I can grant user with the follow commands before:

mysql> GRANT ALL PRIVILEGES ON test.* TO testuser@"%" IDENTIFIED BY "testpw" ;
mysql> create database test;

but now as I log in with testuser and testpw, it's always show:
ERROR 1045: Access denied for user 'testuser'@'localhost'(using password:YES)

My mysql version is 4.020d, I had move the data folder to another drive by configing the my.ini. And days before move back the data folder(also delete my.ini at the same time.)

[coopster]

Welcome to WebmasterWorld, lecter.

I'm not certain if this is your issue or not, but there was a bug early on in that version of MySQL that may be your very same issue.

[webmasterworld.com...]

If not, let us know and we'll try to offer up some other ideas to troubleshoot.

[old_expat]

Please allow me to join this as I had an almost identical experience today when trying to install PHP2 directory script. My version of PHP is 4.3.11 installed on my own VPS where I have root access.

I set up the database username_directory with CPanel, then added username, the added user to database.

I also went through the GRANT ALL PRIVILEGES using PUTTY and shell access. I'm not sure how to do it with a query .. or even if I can

I kept getting the "access denied to [e-mail] .."

PHPMYADMIN still shows the "no privileges" icon.

I have installed 2 other databases, but I did them with a query.

Maybe something wrong with syntax?