install phpMyAdmin On CentOS 8

in CentOS 8

Step 1 : Visit phpMyAdmin page and check the latest available package https://www.phpmyadmin.net/downloads/. Save version to variable.

export PHPMYADMIN_VER="4.9.1"

Step 2 : we install the phpmyadmin package:

curl -o phpMyAdmin-${PHPMYADMIN_VER}-all-languages.tar.gz https://files.phpmyadmin.net/phpMyAdmin/${PHPMYADMIN_VER}/phpMyAdmin-${PHPMYADMIN_VER}-all-languages.tar.gz

Step 3 : Extract

tar -xvf phpMyAdmin-${PHPMYADMIN_VER}-all-languages.tar.gz
rm phpMyAdmin-*.tar.gz

Step 4 : Move the folder to /usr/share/phpmyadmin.

sudo mv phpMyAdmin-${PHPMYADMIN_VER}-all-languages /usr/share/phpmyadmin

Step 5 : Create a tmp directory for phpMyAdmin.

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

Step 6 : Create phpMyAdmin configuration

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

Edit phpMyAdmin configuration file

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

Set a blowfish secret (Needs to be 32 chars long) Generate blowfish secret : https://passwordsgenerator.net/. And Configure Temp directory

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

Step 7 : Create an alias in the Apache web server

sudo nano /etc/httpd/conf.d/phpMyAdmin.conf

Copy and paste the below code.

# 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>

Step 8 : Test Apache configuration and Restart httpd service.

sudo apachectl configtest
sudo systemctl restart httpd

Step 9 : SELinux

Create SELinux policies

sudo yum install -y policycoreutils-python-utils
sudo semanage fcontext -a -t httpd_sys_rw_content_t '/usr/share/phpmyadmin/'
sudo restorecon -Rv '/usr/share/phpmyadmin/'

Step 10 : Open the URL http://ServerIP/phpmyadmin

Login to phpMyAdmin dashboard

Step 11 : Setup the phpMyAdmin configuration storage

Click on create

Done!

Add Comment