8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » Mysql » Here

Install phpMyAdmin On Linux

This article describes two methods of installing phpMyAdmin on Oracle Linux 6.5.

Related articles.

Yum Installation

The simplest way to get phpMyAdmin on a Linux box is to install it from the software repository. Unfortunately, this is a significantly older version of phpMyAdmin than is available for manual installation.

Download the latest Extra Packages for Enterprise Linux repository configuration RPM.

# wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
# rpm -Uvh epel-release-6-8.noarch.rpm

With the repository in place we can install phpMyAdmin, along with the HTTP server and PHP from the regular yum repository.

# yum install phpMyAdmin httpd php -y

If you are using phpMyAdmin to access servers other than localhost, edit the "/etc/phpMyAdmin/config.inc.php" file, adding in a copy of the server section for each server you are planning to manage.

Edit the "/etc/httpd/conf.d/phpMyAdmin.conf" file, adding in any IP addresses that need access to phpMyAdmin.

Allow from 127.0.0.1 192.168.0.4

Start the HTTP server and make sure it restarts automatically on reboot.

# chkconfig httpd on
# service httpd start

If you are using the Linux firewall, you will need to punch a hole in the firewall, as described here.

# iptables -A INPUT -p tcp --dport 80 -j ACCEPT
# service iptables save

The phpMyAdmin console will now be available from a URL such as "http://localhost/phpMyAdmin".

Manual Installation

Download the latest version of the software from phpmyadmin.net.

Install the HTTP server, PHP and the necessary mysql components from the regular Yum repository.

# yum install httpd php php-mysql php-mbstring php-mysqli -y
Install two support packages from the EPEL repository.
# wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm
# rpm -Uvh epel-release-6-8.noarch.rpm
# yum install php-mcrypt php-php-gettext -y

Start the HTTP server and make sure it restarts automatically on reboot.

# chkconfig httpd on
# service httpd start

If you are using the Linux firewall, you will need to punch a hole in the firewall, as described here.

# iptables -A INPUT -p tcp --dport 80 -j ACCEPT
# service iptables save

Unzip the phpMyAdmin software into the "/var/www/html" directory and rename the directory to simplify it.

unzip -d /var/www/html phpMyAdmin-4.1.13-english.zip
mv /var/www/html/phpMyAdmin-4.1.13-english /var/www/html/phpMyAdmin

Create a new config file.

cp /var/www/html/phpMyAdmin/config.sample.inc.php /var/www/html/phpMyAdmin/config.inc.php

If you are using phpMyAdmin to access servers other than localhost, edit the "/etc/phpMyAdmin/config.inc.php" file, adding in a copy of the server section for each server you are planning to manage.

The phpMyAdmin console will now be available from a URL such as "http://localhost/phpMyAdmin".

Additional Information

Since this is a database administration tool, it makes sense to enable HTTPS access to it. Enabling HTTPS access to Apache servers is discussed here.

For more information see:

Hope this helps. Regards Tim...

Back to the Top.