When managing databases on a LAMP (Linux, Apache, MySQL/MariaDB, PHP) stack, one of the most useful tools you can add is phpMyAdmin. It provides an intuitive web-based interface for managing MySQL or MariaDB, making database administration much easier — even for beginners.

In this tutorial, we’ll walk through the process of installing phpMyAdmin on AlmaLinux OS with an existing LAMP environment.

Why Use phpMyAdmin?

phpMyAdmin is a free and open-source application designed to simplify database management. Instead of running SQL commands manually in the terminal, you can use a browser-based GUI to handle tasks such as:

• Creating, modifying, and deleting databases and tables
• Importing and exporting databases
• Executing SQL queries
• Managing users and permissions

Its simplicity, combined with robust functionality, makes phpMyAdmin a valuable tool for webmasters, developers, and hosting clients alike.

Prerequisites

Before beginning, ensure that you have:

• An AlmaLinux server with the LAMP stack installed
• Apache, PHP, and MariaDB/MySQL running properly
• SSH access to your server

If you need help setting up LAMP first, RackNerd offers step-by-step tutorials and VPS hosting solutions to get you started quickly.

Step 1: Update Your System

Log in to your server via SSH and update your package repository:

dnf update -y

Keeping your server updated ensures you’re working with the latest packages and security patches.

Step 2: Install Required Tools

Next, install a few essential Linux utilities:

dnf install nano wget zip -y

These tools will help with configuration and file management during the setup.

Step 3: Enable EPEL and Remi Repositories

phpMyAdmin is available via the Remi repository, which must be enabled first. Run the following commands:

dnf -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm

dnf -y install https://rpms.remirepo.net/enterprise/remi-release-8.rpm

Then install the PHP autoloader package:

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

Step 4: Install phpMyAdmin

Now install phpMyAdmin from the Remi repository:

dnf –enablerepo=remi install phpMyAdmin -y

Once installed, restart Apache to apply the changes:

systemctl restart httpd

Step 5: Verify Services

Check the status of your LAMP services to ensure everything is running properly:

service httpd status && service mariadb status

php -v

Step 6: Configure phpMyAdmin Access

By default, phpMyAdmin restricts access to localhost. To allow remote access, edit the configuration file:

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

Locate the line that says:

Require local

Replace it with:

Require all granted

Save and exit the editor (CTRL+X, then press Y, and hit Enter).

Finally, restart Apache once more to apply the changes:

systemctl restart httpd

Step 7: Access phpMyAdmin

Open your web browser and visit:

http://your-server-ip/phpmyadmin

You’ll be greeted with the phpMyAdmin login screen. Log in using your MySQL or MariaDB root credentials (set during mysql_secure_installation).

From here, you can begin managing your databases through an intuitive web interface.

Conclusion

Congratulations! You’ve successfully installed phpMyAdmin on your AlmaLinux server running LAMP. With phpMyAdmin, managing databases is much easier, whether you’re creating tables, importing data, or configuring user permissions.

At RackNerd, we provide affordable and high-performance hosting solutions — from VPS to dedicated servers — optimized for running web applications like phpMyAdmin. Our team is available 24×7 to support your projects and ensure smooth operation.

Get started today at racknerd.com and experience reliable hosting that empowers your websites and applications.