cwarn23 Posted December 23, 2008 Share Posted December 23, 2008 I have xampp which comes with phpmyadmin 2.11.7 and was working a week ago. But for some reason, phpmyadmin cannot connect to mysql as the connection is rejected (according to the error messages). But the thing that makes it really weard is that although I haven't altered any configurations in phpmyadmin for this to happen, my other php pages can read the mysql databases fine. Error messages: 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. ======== Cannot connect: invalid settings. Since it is xampp I am using, my default user and pass for mysql as 'root' for the user and no password. And the phpmyadmin configuration file looks like the following: <?php /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = 'xampp'; /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type and info */ $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; $cfg['Servers'][$i]['extension'] = 'mysql'; /* User for advanced features */ $cfg['Servers'][$i]['controluser'] = 'pma'; $cfg['Servers'][$i]['controlpass'] = ''; /* Advanced phpMyAdmin features */ $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; $cfg['Servers'][$i]['history'] = 'pma_history'; $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; /* * End of servers configuration */ ?> Does anybody understandy why only phpmyadmin can't read mysql as I don't want to have to make my own version of phpmyadmin. Quote Link to comment https://forums.phpfreaks.com/topic/138128-solved-phpmyadmin-access-denied-error/ Share on other sites More sharing options...
cwarn23 Posted December 24, 2008 Author Share Posted December 24, 2008 I just discovered when I installed mediawiki on xampp, it changed the mysql root password since mediawiki had full permissions to mysql. (before I had no password) So I just found out all I need to do is set that new password (mediawiki made) to any scripts installed before mediawiki and to phpmyadmin. Strange for a cms to do that but solved. *Solved* Quote Link to comment https://forums.phpfreaks.com/topic/138128-solved-phpmyadmin-access-denied-error/#findComment-722970 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.