Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 $

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


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

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… 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


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.