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

[elnasiru96]

Gudday fellow programmers. I'm in a big mess.
I'm using Wamp, and my mysql server has a user= 'root, with password='otlPHP07'.
yesterday i created a database among others and added a user='user' with grants/privileges for update,delete,insert,select.
in phpmyadmin i saw the privileges for 'user' but then. BOOOOMMMM!!
after quiting mysql cmdline. I can't re_access it again with the password above and i cant even access phpmyadmin on the browser. i just see " Access denied for user 'user'@'localhost' (using password: YES)". Pls how can i resolve this issue. i have alot of work to do and my databse is not even backed up. thanx:frown:

 

[misson]

As always, check the manual.

 

[mandy0]

check if you have removed 127.0.0.1 ip from allowed ip list in mysql database config. I don't exactly remember how to do it.. but google is always there to help you. And PHPMyAdmin access might be blocked due to wrong password of root.

 

[contact85]

re configure your database, maybe ,

 

[Tariqul Islam]

maybe your newly created user 'user' have no password. the password is set for 'root' but not for 'user'. check it. try to login with user and no password.