Installing and securing phpMyAdmin 4 on CentOS 6

phpmyadminThis guide will explain how to set up phpMyAdmin 4 on a CentOS 6 VPS and configure it to use SSL.
PhpMyAdmin is a web based MySQL administration tool made to make MySQL administration much easier. PhpMyAdmin needs to have a web server (for example Apache) and at least PHP 5.2 and MySQL 5 installed on the server.

To install Apache, MySQL and PHP, use the following command:

yum install httpd mysql-server php php-mysql php-gd php-mbstring

Start Apache and MySQL services:

service httpd start
service mysqld start

Set the Apache and MySQL services to start automatically when the virtual server boots:

chkconfig httpd on
chkconfig mysqld on

Set a MySQL root password using the following command:


Follow the instructions; enter your new MySQL root password, say ‘Yes’ to all the options and your MySQL installation should now be secure.

Install OpenSSL and mod_ssl packages using the following command:

yum install mod_ssl openssl

Download and extract the latest version of phpMyAdmin available at

cd /root
tar -xzf /root/phpMyAdmin*.tar.gz -C /var/www/html/
mv /var/www/html/phpMyAdmin-4.0.9-all-languages /var/www/html/php-My-Admin
cd /var/www/html/php-My-Admin

Edit the ‘’ configuration file and add the following line below ‘/* Authentication type */’:

$cfg['ForceSSL'] = true;

Next step is to generate a self-signed certificate.

Generate private key:

openssl genrsa -des3 -out 4096

Generate CSR:

openssl req -new -key -out

Generate Self Signed Key:

openssl x509 -req -days 700 -in -signkey -out

Copy the files to the ‘/etc/httpd/ssl/’ directory:

mkdir -p /etc/httpd/ssl/
cp /etc/httpd/ssl/
cp /etc/httpd/ssl/

Create new virtual hosts in Apache, for example:

vi /etc/httpd/conf.d/
NameVirtualHost *:80
NameVirtualHost *:443

<VirtualHost *:80>
DocumentRoot "/var/www/html/php-My-Admin/"
     <Directory /var/www/php-My-Admin/>
         Options Indexes FollowSymLinks MultiViews
         AllowOverride All
         Order allow,deny
         allow from all
ErrorLog logs/your-domain.com_error_log
TransferLog logs/your-domain.com_access_log
LogLevel warn

<VirtualHost *:443>
DocumentRoot "/var/www/html/php-My-Admin/"
 SSLEngine on
 SSLProtocol all -SSLv2
 SSLCertificateFile /etc/httpd/ssl/
 SSLCertificateKeyFile /etc/httpd/ssl/
     <Directory /var/www/php-My-Admin/>
         Options Indexes FollowSymLinks MultiViews
         AllowOverride All
         Order allow,deny
         allow from all
ErrorLog logs/
TransferLog logs/
LogLevel warn

Restart Apache service for the changes to take effect:

service httpd restart

Open your popular web browser and access the phpMyAdmin interface at

You will receive a warning about the SSL certificate not being trusted. This is normal and is expected. The SSL certificate we created is self-signed which is why the web browser is complaining. You can safely ignore that, accept the certificate and proceed to log in to phpMyAdmin.

phpmyadmin vps

Of course, you don’t have to do any of this if you use one of our Linux VPS Hosting services, in which case you can simply ask our expert Linux admins to install phpMyAdmin for you. They are available 24×7 and will take care of your request immediately. For updates, you can also refer to our guide on How to Install phpMyAdmin on CentOS 8.

PS. If you liked this post please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.

2 thoughts on “Installing and securing phpMyAdmin 4 on CentOS 6”

Leave a Comment

To prove you are human please solve the following *