How To Install phpMyAdmin on CentOS 8 / RHEL 8

Posted on 75 views

How do I Install phpMyAdmin on RHEL / CentOS 8 Linux system?. In this blog post, we will cover how to install and Configure phpMyAdmin on RHEL 8. phpMyAdmin is an open source software tool written in PHP for administering MySQL and MariaDB database servers from a Web interface.

phpMyAdmin has support for a wide range of operations on MySQL, MariaDB, and Drizzle. With this tool, you can manage databases, tables, columns, relations, indexes, users, permissions, and others through an intuitive and easy to use web interface.

For Ubuntu / Debian, refer to Install Latest phpMyAdmin on Ubuntu

Install and Configure phpMyAdmin on RHEL / CentOS 8

Below are the steps you’ll follow to install and configure phpMyAdmin on RHEL 8. The dependencies required are PHP, Apache Web Server and Database server to be managed.

Step 1: Install PHP and extensions required

phpMyAdmin is written in PHP and you’ll need it installed on your RHEL / CentOS 8 server.

sudo dnf -y install @php
sudo dnf -y install php-zip php-json php-fpm

Ensure php-mysqlnd extension is installed.

sudo yum -y install php-mysqlnd

Start and enable FPM service

sudo systemctl enable --now php-fpm

Step 2: Install MariaDB/MySQL Database Server

The next step is to install the MariaDB/MySQL database server. Follow guides below to install MariaDB or MySQL on RHEL 8.

Step 3: Install Apache Web Server

phpMyAdmin support both Apache and Nginx as web server. We chose Apache httpd server because it is the most used Web server in enterprise and RHEL ecosystem.

Use our guide below to install Apache web server on RHEL 8.

Step 4: Install phpMyAdmin on RHEL 8

Visit phpMyAdmin downloads page and check the latest available package. Then download the file to your local system.

wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz

Extract downloaded Archive

tar xvf phpMyAdmin-latest-all-languages.tar.gz

Move the folder to /usr/share/phpmyadmin.

rm phpMyAdmin-latest-all-languages.tar.gz
sudo mv phpMyAdmin-*/ /usr/share/phpmyadmin

Create directory for phpMyAdmin temp files.

sudo mkdir -p /var/lib/phpmyadmin/tmp
sudo chown -R apache:apache /var/lib/phpmyadmin

Create directory for phpMyAdmin configuration files such as htpass file.

sudo mkdir /etc/phpmyadmin/

Create phpMyAdmin configuration file.

sudo cp /usr/share/phpmyadmin/config.sample.inc.php  /usr/share/phpmyadmin/config.inc.php

Edit the file

sudo vim /usr/share/phpmyadmin/config.inc.php

Set a secret passphrase – Needs to be 32 chars long

$cfg['blowfish_secret'] = 'H2OxcGXxflSd8JwrwVlh6KW6s2rER63i'; 

Configure Temp directory

$cfg['TempDir'] = '/var/lib/phpmyadmin/tmp';

Step 5: Configure Apache web Server

Create phpMyAdmin Apache configuration file.

sudo vim /etc/httpd/conf.d/phpmyadmin.conf

Add below data:

# Apache configuration for phpMyAdmin
Alias /phpMyAdmin /usr/share/phpmyadmin/
Alias /phpmyadmin /usr/share/phpmyadmin/
 

   AddDefaultCharset UTF-8
 
   
     # Apache 2.4
     Require all granted
   
   
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   

You can restrict access from specific IP by adding line like below

Require ip 127.0.0.1 192.168.0.0/24

Validate Apache configuration.

$ sudo apachectl configtest
Syntax OK

Restart httpd service to load new configuration,

sudo systemctl restart httpd

Step 6: Configure SELinux and Firewall

If you have SELinux in Enforcing mode, you’ll get Permission denied error when you try to access phpMyAdmin page. Allow httpd to serve content in the phpmyadmin directory.

sudo semanage fcontext -a -t httpd_sys_content_t "/usr/share/phpmyadmin(/.*)?"

Apply the policy by running the command.

sudo restorecon -Rv /usr/share/phpmyadmin

Allow http port in the firewall.

sudo firewall-cmd --add-service=http --permanent

Reload firewall reload configuration.

sudo firewall-cmd --reload

Step 7: Access phpMyAdmin Web interface on RHEL 8

Open the URL http://[ServerIP|Hostname]/phpmyadmin

install-phpmyadmin-rhel8-login

Login to phpMyAdmin dashboard with your Database credentials – username & password.

install-phpmyadmin-rhel8-dashboard-1024x382

Congratulations!. You have successfully installed phpMyAdmin on RHEL 8 / CentOS 8.

coffee

Gravatar Image
A systems engineer with excellent skills in systems administration, cloud computing, systems deployment, virtualization, containers, and a certified ethical hacker.