Simple guide on how to install phpMyAdmin on AlmaLinux, Rocky Linux, and Ubuntu. phpMyAdmin is a web-based database management tool that is widely used for MySQL and MariaDB databases.

For AlmaLinux and Rocky Linux:

Step 1: Install EPEL Repository

sudo dnf install epel-release

Step 2: Install phpMyAdmin

sudo dnf install phpMyAdmin

Step 3: Configure phpMyAdmin

Edit the phpMyAdmin configuration file:

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

Find and replace the following lines:

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

Save the file and restart Apache:

sudo systemctl restart httpd

Step 4: Access phpMyAdmin

Open your browser and navigate to http://your_server_ip/phpMyAdmin. Log in with your MySQL/MariaDB username and password.

For Ubuntu:

Step 1: Install phpMyAdmin

sudo apt update
sudo apt install phpmyadmin

During the installation, you will be prompted to choose a web server. Select apache2 using the spacebar and press Enter.

Step 2: Configure phpMyAdmin

sudo nano /etc/apache2/conf-available/phpmyadmin.conf

Add the following lines at the end:

<Directory /usr/share/phpmyadmin>
    Options SymLinksIfOwnerMatch
    DirectoryIndex index.php
</Directory>

Save the file and enable the configuration:

sudo a2enconf phpmyadmin
sudo systemctl restart apache2

Step 3: Access phpMyAdmin

Open your browser and navigate to http://your_server_ip/phpmyadmin. Log in with your MySQL/MariaDB username and password.

Conclusion:

You have successfully installed phpMyAdmin on AlmaLinux, Rocky Linux, and Ubuntu. Use phpMyAdmin to manage your MySQL or MariaDB databases through an easy-to-use web interface. Keep your phpMyAdmin installation up-to-date for security reasons.