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-fpmEnsure php-mysqlnd extension is installed.
sudo yum -y install php-mysqlndStart 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.gzExtract downloaded Archive
tar xvf phpMyAdmin-latest-all-languages.tar.gzMove the folder to /usr/share/phpmyadmin.
rm phpMyAdmin-latest-all-languages.tar.gz
sudo mv phpMyAdmin-*/ /usr/share/phpmyadminCreate directory for phpMyAdmin temp files.
sudo mkdir -p /var/lib/phpmyadmin/tmp
sudo chown -R apache:apache /var/lib/phpmyadminCreate 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.phpEdit the file
sudo vim /usr/share/phpmyadmin/config.inc.phpSet 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.confAdd below data:
# Apache configuration for phpMyAdmin
Alias /phpMyAdmin /usr/share/phpmyadmin/
Alias /phpmyadmin /usr/share/phpmyadmin/
<Directory /usr/share/phpmyadmin/>
AddDefaultCharset UTF-8
<IfModule mod_authz_core.c>
# Apache 2.4
Require all granted
</IfModule>
<IfModule !mod_authz_core.c>
# Apache 2.2
Order Deny,Allow
Deny from All
Allow from 127.0.0.1
Allow from ::1
</IfModule>
</Directory>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 OKRestart httpd service to load new configuration,
sudo systemctl restart httpdStep 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/phpmyadminAllow http port in the firewall.
sudo firewall-cmd --add-service=http --permanentReload firewall reload configuration.
sudo firewall-cmd --reloadStep 7: Access phpMyAdmin Web interface on RHEL 8
Open the URL http://[ServerIP|Hostname]/phpmyadmin
Login to phpMyAdmin dashboard with your Database credentials – username & password.
Congratulations!. You have successfully installed phpMyAdmin on RHEL 8 / CentOS 8.
Recommended books to read:
- Best Books to learn Web Development – PHP, HTML, CSS, JavaScript and jQuery
- Best Books To Master Web Design
- Best Books To Learn CSS & CSS3
- Best Books To Learn HTML & HTML5
- Best Apache and Nginx reference Books
Enjoy administering MySQL/MariaDB database operations from a web dashboard. You can also check:
Other interesting guides:
Monitoring MySQL / MariaDB with Prometheus in five minutes
Install Docker and Docker Compose on RHEL 8
How to Install Netdata on RHEL 8
