Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have installed PHPMyAdmin on a windows machine running IIS 7.0.
We are able to connect to MySQL using command-line, But we are not able to connect using PHPMyAdmin.
The error displayed is: Error #1045 Cannot log in to the MySQL server.
Can somebody please help?

PHP Version 5.4.0
mysqlnd 5.0.10 - 20111026 - $Revision: 323634 $
phpMyAdmin-3.5.4-rc1-all-languages.7z

EDIT :
I followed the link below with no success, mean i changed that password but phpmyadmin still has that error...
C.5.4.1.1. Resetting the Root Password: Windows Systems

Thanks.

share|improve this question
    
is any body home? –  SilverLight Nov 13 '12 at 8:28

1 Answer 1

Try te following:

1) Login to MySQL server using your console

2) update mysql.user set PASSWORD=PASSWORD('newpassword') where User='root';

3) flush privileges;

4) service mysql restart

See if you can access your databases using phpmyadmin. It would be nice if you did provide more information.

share|improve this answer
    
thanks for the answer... i do that, but that error is still out there! –  MoonLight Nov 13 '12 at 9:17
    
i edit my question! –  SilverLight Nov 13 '12 at 9:18
    
See superuser.com/questions/446764/… Maybe it helps –  val0x00ff Nov 13 '12 at 9:21
    
thanks for the link -> no help -> i still have that error. –  SilverLight Nov 13 '12 at 10:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.