Install and Configure phpMyAdmin On CentOS 8

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, 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..

How 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

Advertisements

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

Advertisements
# 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

 

Advertisements

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

 

Advertisements

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

Advertisements
# 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 ReadHow 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.

Leave a Reply

Your email address will not be published.

TechsBucket
Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock