Connection for controluser as defined in your configuration failed.

[casper_2095]

It's just as easy to create the user as it is to comment out the possibility... (use your own root password on this first line)

john@lappy:/etc/phpmyadmin$ mysql --user=root --password=password
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 231
Server version: 5.0.75-0ubuntu10.2 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create user 'phpmyadmin'@'localhost' identified by 'password';
Query OK, 0 rows affected (0.03 sec)

mysql> grant all privileges on *.* to 'phpmyadmin'@'localhost' with grant option;
Query OK, 0 rows affected (0.00 sec)

Worked for me.

[swiftsam]

For what it's worth, I had these problems when phpmyadmin was upgraded as I moved from 8.04 to 9.10. This thread was great, but my attention span must be too short today to make all of the changes appropriately.

What did work, and was super easy was to completely remove phpmyadmin and reinstall it.

sudo apt-get remove --purge phpmyadmin
sudo apt-get install phpmyadmin

Obviously not good if you have lots of customizations in your config files, but worked like a charm for me.

[matt_007]

Hi guys , i recently had the exact problem after setting up mysql database security/Pma account .
I tried a number of things , and this is what worked for me :

-xampp/phpmyadmin/config.inc.php

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

-Added 'root' or your 'user' in place of 'pma'
-And put the password in for the root account.

Maybe this works because you are defining the 'root' account which has all the privileges ,
and the reason that warning comes up is because 'pma' account has no privileges set??

Or it could be that 'Pma' does not have the password verified as you can see above , or if you added a password for the 'pma' account in the mysql/privileges tab , and it has not been updated in the config.inc.php.

If i am completely wrong , i am a newbie at this

[Annelize]

I have been trying to install LAMP server on Ubuntu 10.04 but having difficulty. The error message that comes up in my browser is "Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly." Despite reinstalling php, as suggested in this thread, it is still not working.

Help would be much appreciated as I am not too familiar with Linux.
Thank you!

[Dngrsone]

I just ran into this problem after an update to MySQL (running 10.4 AMD-64). Turns out the problem was that MySQL was not running.

To get it running (at least for the current session) try this in a terminal:

 sudo service mysql start

[tagnu]

Hi all,

I had the same error after installing lampp on a new ubuntu box.

Running

mysqlmysqladmin -u root -p version

Returned

UNIX socket /var/run/mysqld/mysqld.sock

Which meant, there was another instance of mysql running on the system.

Got it resolved after stopping the current server and running lampp again.

sudo service mysql stop
sudo /opt/lampp/lampp start

Thank you.

To get access to mysql prompt from command line, pass the new socket path with --sock option.

mysql -u root -p --sock /opt/lampp/var/mysql/mysql.sock

References:
http://dev.mysql.com/doc/refman/5.1/...ysql-sock.html
http://www.linuxforums.org/forum/red...sponding.html#

[mistaguy]

-the problem could that mysql server is not started....you can work around it using the following options:
(1)use
root@wazzabanga:/home/mistaguy# mysqld -u root
the server should start and so u can now access mysql using
root@wazzabanga:/home/mistaguy# mysql u root p
(2)incase this fails; use the option
mysqld --verbose --help
this will give u options that u can use to start the server. u can use the following but its risky in that any one can access your server
root@wazzabanga:/home/mistaguy# mysqld --skip-grant-tables
punch in the following to access the mysql
root@wazzabanga:/home/mistaguy# mysql
once mysql is okay by using any of the options above, u can access phpmysqladmin from your browser as usual provide u provide the okay user details

[acompay]

just create a mysql user through the terminal and grant all privileges that solves the problem

Please, I have this same problem but do not know how to create a mysqul user and gran all privileges. Where can I find this method? I am using Ubuntu 10.04.
I would appreciate very much your help!
Regards,

[tagnu]

Check this http://ubuntuforums.org/showthread.p...2326&page=3#21

Please, I have this same problem but do not know how to create a mysqul user and gran all privileges. Where can I find this method? I am using Ubuntu 10.04.
I would appreciate very much your help!
Regards,

[carsonrose]

I found how to correct the problem in case anyone else needs a quick fix:

When recently upgrading my server to Ubuntu 9.04, phpMyAdmin was also upgraded to version 5.0.75. When I loaded up the new version, I was alarmed to find a new error message that read: Connection for controluser as defined in your configuration failed.

It turned out this error was due to the fact that version 5 of phpMyAdmin adds support for a new feature known as a linked-tables infrastructure. This infrastructure allows for new features such as bookmarks, comments, SQL-history, PDF-generation, and field contents transformation. The problem was that this new feature is enabled by default, with generic credentials set up for the controluser. If you don't have your database set up for the infrastructure, you will see the error. I have no use for these new features, so I'd rather just not mess with them. If you do want to enable the advanced features, here is an informative post about doing so on Ubuntu. If you just want to disable the linked-tables infrastructure, which is often the easiest and least intrusive way, just follow these steps:

1. Type nano /etc/phpmyadmin/config.inc.php in the Linux terminal. You can substitute nano for vi or your favorite text editor.
2. Find the two blocks of text that read:

$cfg['Servers'][$i]['controluser'] = $dbuser;
$cfg['Servers'][$i]['controlpass'] = $dbpass;

one is near the top embedded in an if statement, and the other is towards the bottom. The text is not exactly the same for each block, but $cfg['Servers'][$i]['controluser'] is what matters. The block that is actually used by phpMyAdmin depends on your setup, but just for simplicity we will apply the change to both.
3. Just comment out those four lines by adding a // in front of each one.
4. Save, and the error should disappear next time you access phpMyAdmin. If you are still having trouble, feel free to post a comment.

Worked for me!