How to Install phpMyAdmin on AlmaLinux 9

Prerequisites:

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

For detailed installation, refer to LAMP Stack on Almalinux 9

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

Enabling the EPEL and REMI repository,

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

Install the php-fedora-autoloader,

dnf install https://rpms.remirepo.net/enterprise/9/remi/x86_64/php-fedora-autoloader-1.0.1-2.el9.remi.noarch.rpm

Install the phpMyAdmin package,

dnf --enablerepo=remi install phpMyAdmin

phpMyAdmin inserts its 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>

Create a soft link of the phpMyAdmin default directory to the standard /var/www/html/ directory

ln -s /usr/share/phpMyAdmin/ /var/www/html/phpmyadmin

Accessing phpMyAdmin

Note: Replace the IP address with the actual server's IP address.

http://ip-address/phpmyadmin/

Output: