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

elnasiru96

New Member
Messages
11
Reaction score
0
Points
0
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:
 

mandy0

New Member
Messages
32
Reaction score
0
Points
0
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.
 

Tariqul Islam

New Member
Messages
182
Reaction score
0
Points
0
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.
 
Top