Edit – April 29, 2011 – This is no longer working for me in Ubuntu 10.04 with everything updated. If you can figure it out, please drop a comment!
This took me a bit too long to figure out. Using Ubuntu 8.10 on a server, I wanted to use phpmyadmin to graphically manage my MySQL databases, but disallow root logins for security reasons.
There are two things you must do in the phpmyadmin config file – typically found at /etc/phpmyadmin/config.inc.php:
- Change the ‘auth_type’ to ‘cookie’. This will be under the /* Authentication type */ comment. The line should read as
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
Make sure it is uncommented by removing the “//” before it, and then change the parameter to ‘cookie’ if that’s not already set.
- Add a new line below this, that says
$cfg[‘Servers’][$i][‘AllowRoot’] = FALSE;
That’s it! Very easy but was tough to find in the forums.