01.20.09
How to Disable Root Logins in phpmyadmin with Ubuntu
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.
Happy administrating!
Related posts:
Billy said,
01.20.09 at 10:06 am
I was wondering how to do this a couple of weeks ago. Thanks.
Uncle A said,
01.22.09 at 3:48 am
Thanks, just what every senior citizen needs to know.
Now I can play Solitary feeling secure.
Omar said,
11.24.09 at 1:22 am
I’m trying to figure out which file this is under
Omar said,
11.24.09 at 4:36 am
Never mind, I found it. Thank you.
/etc/phpmyadmin/config.inc.php