The phpMyAdmin is a free open source software tool to handle the administration of MySQL over the web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. We can manage MySQL operations via phpMyAdmin such as managing databases, tables, columns, relations, indexes, users, permissions. These operations can be performed via the user interface. In this tutorial, we will show how to install phpMyAdmin on both CentOS and Ubuntu 16.4.
Install phpMyAdmin on CentOS 7
1) First, you make sure your server is LAMP. A LAMP stack, meaning Linux, Apache, MySQL, and PHP, must be installed on your server.
2) By default, phpMyAdmin package is not included in the current repository. So we need to enable EPEL (Extra Packages for Enterprise Linux) repository on the server. First, we will install the EPEL repository.
rpm -iUvh http://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
3) To make sure the available packages are up to date.
yum update -y
4) Install phpMyAdmin.
yum install phpMyAdmin
5) Configure phpMyAdmin.
Edit configuration file.
vi /etc/httpd/conf.d/phpMyAdmin.conf
You need to allow your Public IP in the configuration file.
Require ip 127.0.0.1
Allow from 127.0.0.1
Require ip “your public ip address”
Allow from “your public ip address”
6) Then save the file.
7) Restart httpd service.
systemctl restart httpd
Now you can access phpMyAdmin via http://server-ip/phpMyAdmin
Install phpMyAdmin on Ubuntu 16.04
1) Make sure server is LAMP.
2) update packages.
apt-get update && apt-get upgrade
3) The phpMyAdmin package is included in the official Ubuntu 16.04 repository and it can be easily installed with the following command.
apt-get install phpmyadmin
4) When you will be prompted to select a web server to configure, hit the space bar to select Apache2 and enter to confirm and continue.
On next screen select “Yes” to configure the database for phpMyAdmin with dbconfig-common.
If you need any further assistance please contact our support department.