Steps to disable root login in phpMyAdmin

Created:

phpMyAdmin: How to disable root login?

When using phpMyAdmin is a good security practice to diable the root login.

To disable the account you need to open the config.inc.php and set allow root to false.

Usually phpMyAdmin is installed in /usr/share/phpmyadmin. If you can find the config file you can use find command to search phpMyAdmin installation directory. If you can't find config.inc.php search for the sample configuration: config.sample.inc.php. Search for AllowRoot and set it to fale:

php $cfg['Servers'][$i]['AllowRoot'] = FALSE;

If this is you first installation you can copy config.sample.inc.php to config.inc.php and disable root.