Why doesn't phpMyAdmin connect to MySQL server?

Posted by Grafica on Server Fault See other posts from Server Fault or by Grafica
Published on 2012-12-14T21:52:11Z Indexed on 2012/12/14 23:07 UTC
Read the original article Hit count: 167

Filed under:
|
|

I'm running xampp on Windows 7, and when I type localhost/phpmyadmin, there is an error:

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Here's what I did, but I'm still not able to connect:

  • In config.inc.php, changed from true to false: $cfg['Servers'[$i]['AllowNoPassword'] = false;
  • Changed password here: localhost/security/xamppsecurity.php
  • In resetroot.bat, typed new password where it says 'password': echo REPLACE INTO user VALUES ('localhost', 'pma', 'password', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0, '', ''); >>resetroot.sql
  • Restarted apache and mySQL

I still get the same error message.

Thanks in advance!

© Server Fault or respective owner

Related posts about mysql

Related posts about xampp