How to Manage Multiple MySQL server using one PhpMyAdmin

phpmyadmin-logophpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions. In this tutorial I will show you how to configure PhpMyAdmin to administrate various MySQL database servers.

To install and run PhpMyAdmin we need to install LAMP stack on the server.

For Ubuntu user please follow the below steps:

For RHEL/ Fedora/ CentOS user:

Now to install PhpMyAdmin on CentOS you need to enable EPEL repository. Please follow this article to install EPEL on CentOS.

Install PhpMyAdmin:

We have to edit the vi /etc/httpd/conf.d/phpMyAdmin.conf file.

Find line that read follows

Replace with your workstation IP address:

Again find the following line:

Replace as follows:

On the MySQL servers:

We have to modify the my.cnf of the MySQL server which we want to administrate through remote PhpMyAdmin. If your my.cnf contains the below lines then just comment them.

On PhpMyADmin Server:

Now we will modify the PhpMyAdmin configuration file.

Search for the below content:

Now we will add our external MySQL database server like the above pattern.

Append below lines to the config files.

Finally we need to restart the Apache web server

Now you should be able to open the PHPmyAdmin via web browser at . You can select MySQL servers you want to connect from the “Server Choice” drop box and access it using your credentials. Thanks!! Have Fun.

The following two tabs change content below.

Tapas Mishra

Sr. Engineer (DevOps)
Loves to work on Opensource products. Having experience on Linux environment. Knowledge on Public cloud services like AWS, Rackspace, DigitalOcean, Linode. Please don't hesitate to give a comment on the posts. Your comments are my strength.

Leave a Reply