How to Install and Configure phpMyAdmin on CentOS 6
Updated by Linode Written by Linode
phpMyAdmin is a web application that provides a GUI to aid in MySQL database administration. It supports multiple MySQL servers and is a robust and easy alternative to using the MySQL command line client.
NoteThis guide is written for a non-root user. Commands that require elevated privileges are prefixed with
sudo. If you’re not familiar with the
sudocommand, you can check our Users and Groups guide.
Before You Begin
To check your hostname run:
hostname hostname -f
The first command should show your short hostname, and the second should show your fully qualified domain name (FQDN).
Update your system:
sudo yum update
Set up a working LAMP stack. Please see the LAMP on CentOS 6 guide if needed.
NoteIf you have installed the
php-suhosinpackage, there are some known issues when using phpMyAdmin. Please visit the Suhosin phpMyAdmin Compatibility Issues page for more information about tuning and workarounds.
Enable the EPEL Repository:
cd ~ wget http://download.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm sudo rpm -ivh epel-release*
Set up Apache with SSL, so your passwords will not be sent over plain text. To do so, go through the SSL Certificates with Apache on CentOS guide.
sudo yum install php-mcrypt
sudo service httpd restart
sudo yum install phpmyadmin
For each virtual host that you would like to give access to your PHPMyAdmin installation, you must create a symbolic link from the document root to the phpMyAdmin installation location (
cd /var/www/example.com/public_html sudo ln -s /usr/share/phpmyadmin
This will create a symbolic link named
phpmyadminin your document root.
By default, phpMyAdmin is configured to only permit access from the localhost (127.0.0.1). You will want to add the IP address of your computer in order to access it.
Make note of the external IP address being used by your home or work computer. This can be found by visiting the following website:
Edit the configuration file located at
/etc/httpd/conf.d/phpMyAdmin.conf, replacing the four instances of
127.0.0.1with the IP address of your home or work computer.
Since you are required to enter your MySQL credentials when using phpMyAdmin, we recommend that you use SSL to secure HTTP traffic to your phpMyAdmin installation. For more information on using SSL with your websites, please consult the guides that address SSL certificates.
Force phpMyAdmin to use SSL in the phpMyAdmin configuration file
/etc/phpmyadmin/config.inc.phpby adding the following lines under the
$cfg['ForceSSL'] = 'true';
sudo service httpd restart
Testing Your phpMyAdmin Installation
To test phpMyAdmin, open your favorite browser and navigate to
https://example.com/phpmyadmin. You will be prompted for a username and password. Use the username “root” and the password you specified when you installed MySQL. Alternatively, you can log in using any MySQL user and retain their permissions.
If you can successfully log in, phpMyAdmin has been installed properly.
You may wish to consult the following resources for additional information on this topic. While these are provided in the hope that they will be useful, please note that we cannot vouch for the accuracy or timeliness of externally hosted materials.
- How to Install MySQL with phpMyAdmin on Debian 7
- How to Install and Configure phpMyAdmin on Debian 8
- How to Install MySQL with phpMyAdmin on Ubuntu 14.04
- How to Install MySQL with phpMyAdmin on Ubuntu 12.04 - Deprecated
- Manage MySQL with phpMyAdmin on Ubuntu 10.10 (Maverick) - Deprecated
This guide is published under a CC BY-ND 4.0 license.