Connection for controluser as defined in your configuration failed

Written by NickWal

Symptom: After upgrade to Ubuntu 9.04 (Jaunty) phpmyadmin continues to work fine but shows the following error on several pages:

“Connection for controluser as defined in your configuration failed.”

Software Versions:

  • Ubuntu Jaunty 9.04
  • Phymyadmin : 3.1.2deb1

Reason: The advanced features available in phpmyadmin require the installation of a database to support them and the phpmyadmin control user should have rights to modify the data in the phpmyadmindatabase

  1. Firstly create the database for advanced features using

    cd /usr/share/doc/phpmyadmin/examples/
    sudo gunzip create_tables.sql.gz
    mysql -u root -p < create_tables_mysql.sql

  2. Check the values of contents of the following variables

    $dbuser=’phpmyadmin’;
    $dbpass=’xxxxxxx’;

in the file /etc/phpmyadmin/config-db.php

You can do this with something like:

> sudo nano -w /etc/phpmyadmin/config-db.php

Finally, Log in to phpmyadmin and create create a username phpmyadmin that can connect from localhost then add add at least SELECT, INSERT, UPDATE, DELETE privelages to the newly created phpmyadmindb for the user phpmyadmin using the password identified from /etc/phpmyadmin/config-db.php

References