WAMP Server: Mysql login Error (Cant open phpmyAdmin)

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

This is very common error encountered while using WAMP server , its because you have not set mySql password and you need to set it first!

Solution :

1) Go to C:\wamp\bin\mysql\mysql5.1.36\bin\
2) mysql.exe -u root -p
3) mysql>
4) Type this query :
     update mysql.user set password=password('1234') where user='root';
5) flush privileges;
6) That's it! now u set password 1234 to mysql.
7) Now whenever you will establish connection with mysql from php pages you will need to provide this password 1234


Thank You,
Have A Nice Day!

0 comments:

Post a Comment