Introduction
phpMyAdmin is a free and open-source tool designed to administer MySQL database management systems using a web interface. It provides a graphical user interface to perform various database management-related tasks.
In this guide, we will show how to install phpMyAdmin on AlmaLinux 8.
Prerequisites
Apache Web Server. First, make sure Apache is already installed on your server. For installation, you can check our Apache web server installation guide.
MySQL. You also need MySQL. You can install it by following our guide.
PHP. To install PHP, you can check our PHP installation guide.
Installation guide
1. Install EPEL
Install EPEL release by running this command:
dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
2. Install REMI repositories.
To install REMI, run this command:
dnf install https://rpms.remirepo.net/enterprise/remi-release-8.rpm
3. Install the fedora-autoloader package
Next, install the fedora-autoloader package:
dnf install http://rpms.remirepo.net/enterprise/8/remi/x86_64/php-fedora-autoloader-1.0.0-5.el8.remi.noarch.rpm
4. Install phpMyAdmin
Now you can install phpMyAdmin by running the following:
dnf --enablerepo=remi install phpMyAdmin
5. Restart Apache Web Server
To enable new configurations, restart the Apache:
systemctl restart httpd
6. Modify the configuration file
By default, access to phpMyAdmin is only enabled from the local IP. However, you can edit the configuration file and enable access from a specific IP.
To do so, open the configuration file:
vi /etc/httpd/conf.d/phpMyAdmin.conf
Find these lines:
Then add the following lines:
It should look like here (write your IP instead of "your_workstation_ip"):
Then save the file and exit (press "Esc", then type :wq and click "Enter").
After you modified the configuration file, make sure to restart Apache:
systemctl restart httpd
7. Access phpMyAdmin
To open phpMyAdmin, open your web browser and enter the URL in the following format:
So you need to simply enter your server IP and /phpmyadmin.
After you enter this, you should see the phpMyAdmin login page on which you can enter MySQL user credentials:
That's all. Now you can manage databases via phpMyAdmin: