This video will walk you through the process step-by-step of installing PHPMyAdmin in Linux CentOS 7 with Lamp based on the previous modules from the Free Hosting for WordPress series.

We’ll cover all the necessary commands, packages, and configurations required for a successful installation. In no time, you’ll have an easy-to-use tool that allows you to manage your databases easily.

Installing PHPMyAdmin

Here are the commands we used in the video:

# Install EPEL Repository (Ignore if it's already installed):
rpm -iUvh http://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

# Update the System to ensure any latest updates to our install:
yum -y update

# Installing phpMyAdmin:
yum -y install phpmyadmin

# Edit PhpMyAdmin Config. file to allow access from the internet:
nano /etc/httpd/conf.d/phpMyAdmin.conf

# EDIT and CHANGE below in the file phpMyAdmin.conf:
Require ip 127.0.0.1 ==> Require all granted
Deny from All ==> Allow from All
#Then exit and save the file with the command (CTRL+X+Y+ENTER)

# Restart Apache & Check Status:
systemctl restart httpd && systemctl status httpd

# Verify that phpMyAdmin is working by visiting http://Your-IP-Or-Domain/phpmyadmin then login with your database Username and password. You can also use root credentials to manage all databases in 1 dashboard.

# IF you can't see access, Restart MariaDB & Check Status:
systemctl restart mariadb && systemctl status mariadb

Moving Forward

If you followed all the steps in the video, you should already have a working PHPMyAdmin that you can access through the internet.

If you are using WordPress alongside PhpMyAdmin, you might also find my other tutorials related to databases and WordPress useful. And make sure to go through the FREE HOSTING for WordPress series.