How to install phpMyAdmin on AlmaLinux 8

Prerequisites:

phpMyAdmin requires a standalone Database or as part of LAMP stack, installed and running on the system.

For detailed installation, refer to LAMP Stack on Almalinux 8

This guide will work on any AlmaLinux 8 system including KVM, OpenVZ or Dedicated Servers.

Enabling the EPEL and REMI repository,

dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
dnf install https://rpms.remirepo.net/enterprise/remi-release-8.rpm

Install the php-fedora-autoloader,

dnf install http://rpms.remirepo.net/enterprise/8/remi/x86_64/php-fedora-autoloader-1.0.0-5.el8.remi.noarch.rpm

Install the phpMyAdmin package,

dnf --enablerepo=remi install phpMyAdmin

phpMyAdmin inserts it's own configuration into the Apache webserver (httpd), to load this new configuration we restart httpd,

service httpd restart

Edit file phpMyAdmin.conf

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

And replace at the top.

<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8

   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       #Require ip 127.0.0.1
       #Require ip ::1
       Require all granted
     </RequireAny>
   </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>

Accessing phpMyAdmin

http://ip-address/phpmyadmin/

Output: