Hi Everyone, today in this post we are going to learn about phpMyAdmin Installation and Configuration step by step on CentOS 8 along with a Video Tutorial. phpMyAdmin is very useful to access MySQL Databases which gives a beautiful Graphical Interface to access all the Databases over the Web Browser.

What is phpMyAdmin 

phpMyAdmin allows you to access all your MySQL Databases Graphically over the Web Browser. This is very useful and helpful to reset forgotten Database usernames and passwords. phpMyAdmin manages Databases of MySQL and MariaDB. Managing databases, tables, columns, relations, indexes, users, and permissions can be performed via Web Browser which gives a good user interface mode and things become interesting and simple so you do not have to perform syntax over the command-line interface.

• Good and Interesting Web Interface
• Create, Drop, Rename, and Alter the Databases
• Manages Privileges of MySQL user accounts
• Creating graphics of your database layout in various formats
• Data can be exported into CSV, SQL, XML, PDF, OpenDocument Text and Spreadsheet, Word
• Allows Administering of Multiple Servers and So On.

Steps to Install phpMyAdmin on CentOS 8

To install and Configure phpMyAdmin, you should have the following services installed and enabled first on your CentOS 8 Server, here are the steps.

Step 1

Install Apache Server

To install Apache Server run the below command and start the services, first update the server.

# yum update -y

# yum install httpd

# systemctl start httpd.service

# systemctl enable httpd.service

Allow the Apache ports in the firewall

#  firewall-cmd --permanent --add-port=80/tcp

#  firewall-cmd --permanent --add-port=443/tcp

Step 2

Install MariaDB

Run the following command to install MariaDB

# sudo yum install mariadb-server

After installation, start MariaDB and enable it on boot

# sudo systemctl start mariadb

# sudo systemctl enable mariadb

Secure installation MariaDB

# mysql_secure_installation

• Enter current password for root (enter for none):
• Set root password? [Y/n] 
• New password :
• Re-enter new password :
• Remove anonymous users? [Y/n] : 
• Disallow root login remotely? [Y/n] : 
• Remove test database and access to it? [Y/n] :
• Reload privilege tables now? [Y/n] : 

Check the status after installation by following command, if MariaDB has successfully started then the status should be active.

# sudo systemctl status mariadb

Step 3

Install PHP 7.XX

Run the below command to install PHP on CentOS 8

# sudo dnf install dnf-utils http://rpms.remirepo.net/enterprise/remi-release-8.rpm

# sudo dnf module list php

# sudo dnf module reset php

# sudo dnf module enable php:remi-7.3

Install some common modules of PHP

# sudo dnf install php php-opcache php-gd php-curl php-mysqlnd

# sudo systemctl enable --now php-fpm

Allow PHP to work with Apache

# sudo chcon -Rt httpd_sys_rw_content_t /var/www

# sudo systemctl restart httpd

Step 4

Install  Extensions 

Install PHP XML Extension

# sudo yum install php-xml

Install Mbstring Extension

# sudo yum install php-mbstring

# sudo service httpd restart

Install Intl Extension

# sudo yum --enablerepo=remi install php-intl

Now install APcu Extension

# wget http://rpms.remirepo.net/enterprise/remi-release-7.rpm
   rpm -Uvh remi-release-7.rpm

# sudo yum install php-pecl-apcu

# sudo service httpd restart

Finally install IMAP php Extension

# sudo yum install php-imap

Step 5

Download and Unzip phpMyAdmin

Download phpMyAdmin from the official website and place it in the Apache root directory.

# sudo cd /var/www/html/

# wget https://files.phpmyadmin.net/phpMyAdmin/5.1.0/phpMyAdmin-5.1.0-all-languages.zip

# unzip phpMyAdmin-5.1.0-all-languages.zip

Step 6

Rename And Allow Apache Ownership

In this step, rename the phpMyAdmin, Configuration file and Allow Apache Ownership

# mv phpMyAdmin-5.1.0-all-languages phpmyadmin

# sudo cd /var/www/html/phpmyadmin

# sudo mv config.sample.inc.php config.inc.php

# sudo chown -R apache:apache /var/www/html/phpmyadmin

Step 7

Update MySQL Secure Password

Edit the config file and define your MySQL secure password. Find the below-given line and save the file once edit done

$cfg[‘blowfish_secret’] = ‘your-secure-password’;

# sudo cd /var/www/html/phpmyadmin

# sudo vi config.inc.php

Note : If you want to reset MySQL secure password, follow the below steps

# mysql -u root -p

# set password for 'root'@'localhost' = password('your-pass');

# flush privileges;

Step 8

Import Tables For phpMyAdmin

Once the file is saved, Import the Tables for phpMyAdmin

# mysql < sql/create_tables.sql -u root -p

Step 9

Create Apache Virtual Host file

Create Apache Virtual Host file in the following Directory for phpMyAdmin

# sudo /etc/httpd/conf.d/

# sudo vi phpmyadmin.conf

Copy and Paste the below-given lines and save the file

Alias /phpmyadmin /var/www/html/phpmyadmin

<Directory /var/www/html/phpmyadmin/>
AddDefaultCharset UTF-8

<IfModule mod_authz_core.c>
# Apache 2.4
<RequireAny>
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>

<Directory /var/www/html/phpmyadmin/setup/>
<IfModule mod_authz_core.c>
# Apache 2.4
<RequireAny>
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>

Restart the Apache Service and Enable it on Boot 

# sudo systemctl restart httpd
 
# sudo systemctl enable httpd

Step 10

Access phpMyAdmin

Finally, open your Web Browser and Put the URL (Replace IP with Your Server IP)

192.168.10.200/phpmyadmin

Also Read :  How to install Android Studio on Linux

Video Tutorial

In this tutorial, we have covered how to install phpMyAdmin on CentOS 8 Operating System step by step. Comment below for your queries and suggestion or you can contact me any time via the contact page. I will be assisting you and try my best to clear your all doubts.