“Connection for controluser as defined in your con

Question

I have just installed XAMPP on my Windows XP machine, and I get an error saying:

Connection for controluser as defined in your configuration failed.

Before I installed XAMPP, I had a MySQL database installed and it had a password. I changed and put the password in config.inc.php for MySQL, and I got this error:

<?php
if (!empty($_SERVER['HTTPS']) && ('on' == $_SERVER['HTTPS'])) {
    $uri = 'https://';
} else {
    $uri = 'http://';
}
$uri .= $_SERVER['HTTP_HOST'];
header('Location: '.$uri.'/xampp/');
exit;
?>

When I try to access index.php, it seems like something is wrong with the XAMPP installation. What can I do to fix this problem?

Answer 1

On Ubunbtu.

Ben's message is close but it's not the root password that is the problem, the problem I found was I had created a password for the phpmyadmin database when I installed it. This password is not carried into the installation on ubuntu so the variable $dbpass=''; in the database settings file is empty and not the password you set.

1. To check you have the right password at the command line login to mysql using the following command: mysql -u phpmyadmin -p try a blank password I found I got access denied, enter the command again using the password you set during installation. If it logs in you now know what the password is.
2. Edit /etc/phpadmin/config-db.php and change $dbpass=''; to $dbpass='Your Password'; and save the file.
3. Edit /etc/dbconfig-common/phpmyadmin.conf change dbc_dbpass=''; to dbc_dbpass='Your Password'; and save the file. Close your browser and reload you will now find the message has gone way.

Answer 2

The problem is that PhpMyAdmin control user (usually: pma) password does not match the mysql user: pma (same user) password.

To fix it, 1. Set the password you want for user pma here:

"C:\xampp\phpMyAdmin\config.inc.php"

$cfg['Servers'][$i]['controlpass'] = 'your_new_phpmyadmin_pass';

(should be like on line 32)

Then go to mysql, login as root, go to: (I used phpmyadmin to go here)

Database: mysql »Table: user

Edit the user: pma

Select "Password" from the function list (left column) and set "your_new_phpmyadmin_pass" on the right column and hit go.

Restart mysql server.

Now the message should disappear.

Answer 3

1. Open phpMyAdmin in a browser and log in as root.
2. Create a database called phpmyadmin
3. Create a user called pma and set the "host" to the hostname or IP address of your web server (if the web server and MySQL are on the same box use localhost), make a note of the password, and grant the new user full control over the phpmyadmin database. It is recommended that this user does not have access to anything other than this database.
4. Go to the phpMyAdmin installation directory, where you should find a sub-directory called sql.
5. In sql you will find a file called create_tables.sql. Open it in a text editor.
6. In phpMyAdmin, select the phpmyadmin database and click on the "SQL" tab.
7. Copy/paste the entire text from create_tables.sql into the text box, and run the query.

8. Open the config.inc.php file in the phpMyAdmin install directory, and add the following lines (or change the existing settings if they are already there):

   $cfg['Servers'][1]['pmadb'] = 'phpmyadmin';
   $cfg['Servers'][1]['controluser'] = 'pma';
   $cfg['Servers'][1]['controlpass'] = '<your password>';
   
   // Note: The list below may grow as PMA evolves and more control tables are added
   // Use your common sense! Don't just blindly copypasta, look at what it means!
   $cfg['Servers'][1]['bookmarktable'] = 'pma_bookmark';
   $cfg['Servers'][1]['relation'] = 'pma_relation';
   $cfg['Servers'][1]['userconfig'] = 'pma_userconfig';
   $cfg['Servers'][1]['table_info'] = 'pma_table_info';
   $cfg['Servers'][1]['column_info'] = 'pma_column_info';
   $cfg['Servers'][1]['history'] = 'pma_history';
   $cfg['Servers'][1]['recent'] = 'pma_recent';
   $cfg['Servers'][1]['table_uiprefs'] = 'pma_table_uiprefs';
   $cfg['Servers'][1]['tracking'] = 'pma_tracking';
   $cfg['Servers'][1]['table_coords'] = 'pma_table_coords';
   $cfg['Servers'][1]['pdf_pages'] = 'pma_pdf_pages';
   $cfg['Servers'][1]['designer_coords'] = 'pma_designer_coords';
   

9. Save and close the file.

IMPORTANT - PMA loads the config on login, evaluates it and stores it into the session data so the message will not disappear until you do this:

10. Log out of phpMyAdmin and log in again

Problem solved.

Answer 4

on ubuntu 18.04 in etc/phpmyadmin/config.inc.php comment all the block

Optional: User for advanced features

Answer 5

I had the same issue. In my case Mysql was not started after a reboot. once I started the mysql "service mysql start" everything worked fine.

Answer 6

on ubuntu /etc/phpmyadmin/config-db.php

make sure the password matches your config.inc.php for the control user

also for the blowfish too short error

edit /var/lib/phpmyadmin/blowfish_secret.inc.php and make the key longer