How to Disable root Login Access to PhpMyAdmin

If you are planning on using phpmyadmin on a regular basis to manage your databases over the network (or worse, over the Internet!), you don’t want to use the root account. This is valid not only for phpmyadmin but also for any other web-based interface.

In /etc/phpmyadmin/config.inc.php, look for the following line and make sure the AllowRoot directive is set to FALSE:

Then follow the steps outlined in the above tips to get to the phpmyadmin login page (https://<ip address>/phpmyadmin) and Try to login as root:

Root Access Disabled in Phpmyadmin

Then connect to your MySQL / MariaDB database via the command prompt and, using root credentials, create as many accounts as needed to access one database each. In this case we will create an account named jdoe with password jdoespassword:

Gabriel Cánepa is a GNU/Linux sysadmin and web developer from Villa Mercedes, San Luis, Argentina. He works for a worldwide leading consumer product company and takes great pleasure in using FOSS tools to increase productivity in all areas of his daily work.

Your name can also be listed here. Got a tip? Submit it here to become an TecMint author.