Installing phpMyAdmin

phpMyAdmin is a free, php and web browser based, open source, administration tool for MySQL. If your web application or website requires MySQL database, it is recommended that you install phpMyAdmin for easier database management.

Note
  • This documentation assumes you've already installed the LAMP stack on your VPS. If you haven't done that yet, refer to the LAMP installation guide.

    Additional Information

    Getting your VPS LAMP ready

  • Ensure that you are connected to the server using an SSH client as a root user.

  • You need not follow this documentation, in case you have installed cPanel or Plesk. phpMyAdmin comes pre-installed with these panels.

To Setup MySQL

Check whether the MySQL service is already running by using the command:

service mysqld status

If the service is currently not running, you can start it using the command:

service mysqld start

To Setup MySQL User

Set the MySQL Server's root password.

Note
  • This is the root user for MySQL Server, and is different from the VPS container's root user.

  • Since this is the first login, the service will not require any password to connect as root.

Use the command:

mysqladmin -u root password <your_new_password>

To Install phpMyAdmin

  1. Before you install phpMyAdmin using yum, you will have to install EPEL or RPMForge repository. This is because phpMyAdmin is not included by default in CentOS repository. In this example, EPEL is used.

     

    Execute the following commands:

    cd /tmp wget https://mirror-fpt-telecom.fpt.net/fedora/epel/6/i386/epel-release-6-8.noarch.rpm rpm -ivh epel-release-6-8.noarch.rpm

  2. Proceed with the yum installation of phpMyAdmin using the command:

    yum -y install phpmyadmin

To Configure phpMyAdmin

phpMyAdmin can be accessed only from localhost, by default. To access it from your local system, you will have to change the configuration settings. Edit the file phpMyAdmin.conf, which can be found under /etc/httpd/conf.d.

vi /etc/httpd/conf.d/phpMyAdmin.conf

Edit the file as below:

 

  • Comment the Deny directive,

    AND

  • mention your IP Address for Allow from.

Configuring phpMyAdmin

Note

You may customize the access settings as per hostname, IP Address and IP Address range depending on your needs. It is recommeded that you limit its access for security reasons.

To Restart Apache and Start Using phpMyAdmin

Restart the httpd service using the command:

service httpd restart

Now, you can access https://<Your_IP_Address>/phpMyAdmin or https://<Your_Domain_Name>/phpMyAdmin.

Note

You can customize the settings further as deemed necessary.

Additional Information

phpMyAdmin Documentation