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
- 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
- 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
