INSTALL AND CONFIGURE SECURE PHPMYADMIN ON CENTOS

Step 1: Before installing the phpMyadmin you need to install LAMP stack (Linux, Apache, MySQL, PHP)

Yum install httpd mysql-server php php-mysql

Step 2: Next, we need to start the service

Step 3: This software (phpMyAdmin package) is not available in the CentOS 6 default repositories.
it is available in the EPEL repos (Extra Packages for Enterprise Linux).

We can add access to the EPEL repositories to our system using the below command.

Step 4: Then we need to install phpMyadmin packages using the following command.

Step 5: Next we need to know IP address of the computer you using to access your databases. This is a security purpose so that unauthorized pepole cannot connect.
using the link click here you can find out your IP address.

Step 6: Next we need to configure the phpMyAdmin configuration file using the following command.

Step 7: In this Configuration file we need to change the IP address of 127.0.0.1 with the IP address you found.
There should be four locations that you need to change.

. . .
Require ip 127.0.0.1
. . .
Allow from 127.0.0.1
. . .
Require ip 127.0.0.1
. . .
Allow from 127.0.0.1
. . .

save and close the file.

Step 8: Next you need to restart the server with the following command.

Step 9: Finally you are ready to access your phpmyadmin.

Point your web browser to your VPS IP address or your Domain name followed by /phpmyadmin

Eg: 127.0.0.1/phpmyadmin

Eg: example.com/phpmyadmin

Step 10: Now you will get the Log in page. Use the user root and the password that you selected during the MySQL configuration stage.

After providing the requested credentials, you will have access to the phpMyAdmin interface

Congratulation, you can now access and manage your database software from web interface.