Jump to content

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*

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.