How to Secure phpMyAdmin and install latest phpMyAdmin 4.4.14

phpMyAdmin is tool to manage administration of MySQL or MariaDB , This tool is written in php language and it free and open source tool.We can create, modify and delete and run the mysql query in database.

Here this article will help in installation of latest phpMyAdmin tool version on different linux box like CentOS, Red Hat, Fedora and some points to secure phpMyAdmin from unnecessary activity. Latest phpMyAdmin version 4.4.14.1 is released on 2015-09-08 .

You need to first know that which system should be allow to access that url , default phpMyAdmin is alllowed only from localhost or local server. We need to give our IP or network, which should allow to access phpmyadmin web url. Here I have check my public ip and allowed in configuratiion like below. We need to change on first part of section in /usr/share/phpMyAdmin .There will be Allow from 127.0.0.1 , replace your public ip or network with 127.0.0.1.

If you want to see your public IP , you can check through below online url.

Not allow remote logins , important thing is if you need like root permissions, create a mysql user which have permission to add , create and drop privileges and don’t give grant or file_priv permission.

Try to configure url with SSL or Self signed SSL .

Try to allow through IP Address like we have set in installation configuration , that is allow from IP. Which should be trusted network.

Firewall port 3306 is only allow for trusted network.

Not allow to access phpMyAdmin through shared ip or predictable file location like http://Your-server-ip/phpmyadmin.