XAMPP: phpMyAdmin connection error
contraryo
-
lynayanami Posted messages 39 Status Membre -
lynayanami Posted messages 39 Status Membre -
Good evening everyone.
I am currently developing a site locally using WordPress that I plan to transfer to a remote host soon. To create a database, I installed the XAMPP server a few weeks ago. I created my database by accessing it via my browser through the following URL: http://localhost/phpmyadmin
It was working perfectly, but for a few days now, I can no longer access phpMyAdmin, preventing me from exporting my database to my remote host (OVH). I am getting the following error message:
"phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. Please check the values of "host", "username", and "password" in your configuration and make sure they match the information provided by the MySQL server administrator."
However, I can still access my site via the following URL: http://localhost/wordpress
I also checked the forums for various solutions. So, I cleared the caches of Firefox and Chrome. I also tested private browsing, but with no success.
A WordPress specialist (whom I recommend by the way: http://www.david-bost.fr/) came to help me via Skype. We looked together at the various XAMPP settings, including the MySQL admin settings. We also consulted the wp-config.php.
That is why I am seeking your help to get out of this situation.
Thank you in advance for your responses.
Sincerely.
Configuration: Windows 7 / Firefox 13.0.1
I am currently developing a site locally using WordPress that I plan to transfer to a remote host soon. To create a database, I installed the XAMPP server a few weeks ago. I created my database by accessing it via my browser through the following URL: http://localhost/phpmyadmin
It was working perfectly, but for a few days now, I can no longer access phpMyAdmin, preventing me from exporting my database to my remote host (OVH). I am getting the following error message:
"phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. Please check the values of "host", "username", and "password" in your configuration and make sure they match the information provided by the MySQL server administrator."
However, I can still access my site via the following URL: http://localhost/wordpress
I also checked the forums for various solutions. So, I cleared the caches of Firefox and Chrome. I also tested private browsing, but with no success.
A WordPress specialist (whom I recommend by the way: http://www.david-bost.fr/) came to help me via Skype. We looked together at the various XAMPP settings, including the MySQL admin settings. We also consulted the wp-config.php.
That is why I am seeking your help to get out of this situation.
Thank you in advance for your responses.
Sincerely.
Configuration: Windows 7 / Firefox 13.0.1
1 réponse
Problem solved!
By browsing Anglo-Saxon forums. The technique is to edit the config.inc.php file in the following directory: C:\xampp\phpmyadmin
Then, you need to put this (I didn't have a default password):
Finally, in XAMPP, in the Control Panel Application (startup screen), you need to click on Admin next to MySQL. This will prompt you to enter the username and password: either root and the password you entered in config.inc.php.
By browsing Anglo-Saxon forums. The technique is to edit the config.inc.php file in the following directory: C:\xampp\phpmyadmin
Then, you need to put this (I didn't have a default password):
$cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'xxxxx'; $cfg['Servers'][$i]['AllowNoPasswordRoot'] = false;
Finally, in XAMPP, in the Control Panel Application (startup screen), you need to click on Admin next to MySQL. This will prompt you to enter the username and password: either root and the password you entered in config.inc.php.
lynayanami
Posted messages
39
Status
Membre
1
A huge thank you, I searched for a long time and you were the one who provided me with the answer =)