How To Install phpMyAdmin with Apache on Centos 7

How To Install phpMyAdmin with Apache on Centos 7

phpMyAdmin is an open source tool used for administer MySQL, also offers you to use interface to perform database main tasks like creating, editing, or deleting databases, and managing users and permissions.

Prerequisites

before we start, there are few requirements need to be set it up.
you must have a centos 7 installed on your server, and you must had a LAMP (Linux, Apache, MariaDB, and PHP) stack installed and fully configured, if you don’t have it installed you can follow our guide HOW TO INSTALL APACHE, MYSQL, PHP ON CENTOS 7,
Also make sure that you have a root privileges
Now you can continue with installing phpMyAdmin

Step One – Installing phpMyAdmin

before you start you have to know that phpMyAdmin not available in Centos 7 default repository
to get this package you’ll add additional repo to your system, you can find phpMyAdmin in EPEL repo you can add it by

yum install epel-release

Now you can easily install phpMyAdmin by

yum install phpmyadmin

Step Two – Configure phpMyAdmin

the current configuration to deny access to any connection not being made from the server itself, now we need to modify some lines to specify your server ip address.

vim /etc/httpd/conf.d/phpMyAdmin.conf

now change lines that start with

Require ip 127.0.0.1 or Allow from 127.0.0.1

change the ip address to match your home connection’s ip address
Now you finished, start the apache server to implement your modification by typing:

systemctl restart httpd.service

Step Three – Verify phpMyAdmin

To access your phpMyAdmin interface you just write in your url

http://server_domain_oryour_ ip/phpmyadmin

you can see now your welcome page with username and password required, use your username and password you’ve been edit it when you configured MariaDB users.

You can now manage your database, also you can watch this steps in the video below
and Thats it,if you need any help feel free to ask 🙂

Next Post Previous Post