The maritime parallax

GOSPORT CLOUD

Scroll to Top

PhpMyAdmin installation Centos

December 2020

PhpMyAdmin one of the greatest freebies for a web developer. It is an opensource database management tool for Php and MySQL. Creating a database or adding or a user is simplified using PhpMyAdmin. Installation and configuration is relatively simple.

Centos is very much a bare bones distro, so we need to install the Epel release repository. (Extra Packages for Enterprise Linux ). Log in as root, copy/paste the following.

Step 1: Install Epel Release. Note the -y prevents having to confirm yes for each file download. 

yum install epel-release -y

Step 2: Check for updates.

yum update -y

Step 3: Check if Apache webserver is functioning.

systemctl status httpd

If the output displays active (running) Then go straight to step 4. Otherwise this indicates the webserver is not installed, continue with the rest of step 3 to further install HTTPD

Step 3.1: Install Apcache web server.

yum install httpd -y

Step 3.2 : Start httpd

systemctl start httpd.service

Step 3.3 : Once again check that httpd is active.

systemctl status httpd

Step 3.4 : Now that httpd is active. We need to enable it so that it will restart on a server reboot.

systemctl enable httpd.service

Step 4 : Below is your ip address, copy and paste it into the browser topbar.

The default Apache web page should now be displayed

Step 5 : At last we are ready to install phpMyAdmin.

yum install phpmyadmin -y

PhpMyAdmin will requires a little editing to allow access.
Centos default editor is Vi.
I prefer to use nano, as it is rather easy to use.
Nano is a lightweight editor.

Step 5 :Optional, install Nano text editor

yum install nano -y

Step 6 : Select which editor you prefer to edit the PhpMyAdmin config file.

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

Change every instance of 127.0.0.1, to your own IP address. This will allow your connection to be recognised and permit access. You will have to log in as root and use the root password. From here you can easily add a user and also create databases. Good Luck, I hope this was helpful.