Jump to content

[SOLVED] phpmyadmin access denied error?


cwarn23

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/138128-solved-phpmyadmin-access-denied-error/
Share on other sites

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*

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.