Installing phpMyAdmin on CentOS 8

phpMyAdmin is a free and open-source web-based application that provides a graphical interface to manage MySQL and MariaDB databases. It allows you to easily perform database operations such as create, delete, modify tables, execute SQL queries, import and export data, and much more, all through a user-friendly web interface.

Step 1: Update System Packages

Before starting with the installation, it is recommended to update the system packages to their latest versions. Open a terminal and run the following command:

sudo dnf update

Step 2: Install Apache and PHP

phpMyAdmin requires a web server (Apache) and PHP to be installed on your CentOS 8 system. You can install them using the following command:

sudo dnf install httpd php php-mysqlnd

Step 3: Install and Configure MariaDB

If you don't have MySQL or MariaDB installed, you can install MariaDB using the following command:

sudo dnf install mariadb-server

After the installation, start and enable the MariaDB service:

sudo systemctl start mariadb
sudo systemctl enable mariadb

Then, run the following command to secure your MariaDB installation:

sudo mysql_secure_installation

Step 4: Install phpMyAdmin

Now, you can install phpMyAdmin using the following command:

sudo dnf install phpMyAdmin

During the installation, you may be prompted to select the web server that should be automatically configured for phpMyAdmin. Select "apache" and press Enter.

After the installation, open the `phpMyAdmin.conf` file in a text editor:

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

Find the following line:

Require ip 127.0.0.1

Replace it with:

Require all granted

Save the file and exit the text editor.

Step 5: Restart Services

Restart Apache and MariaDB services to apply the changes:

sudo systemctl restart httpd
sudo systemctl restart mariadb

Step 6: Access phpMyAdmin

You can now access phpMyAdmin by opening your web browser and navigating to `http://your_server_ip/phpmyadmin`. Replace `your_server_ip` with the IP address or domain name of your CentOS 8 server.

Log in with your MariaDB root username and password. You will then have access to the phpMyAdmin dashboard, where you can manage your databases and perform various operations.