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