Why doesn't phpMyAdmin connect to MySQL server?
- by Grafica
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!
