How to Install PhpMyAdmin on CentOS 7 and Ubuntu 16.04?

How to Install PhpMyAdmin on CentOS 7 and Ubuntu 16.04?

How to Install PhpMyAdmin on CentOS 7 and Ubuntu 16.04?

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.

  • 0

Configure and Install Varnish on CentOS/Ubuntu.

Configure and Install Varnish on CentOS/Ubuntu. In this tutorial we can check how to Configure...

About Zabbix

About Zabbix Zabbix is an open source network monitoring tool. It works with a centralized...

Apache HTTPD Web Server – Details and Installation

Apache HTTPD Web Server – Details and Installation Apache HTTPD is one of the most used web...

Configure and Install PostgreSQL on CentOS 7 and 8

Configure and Install PostgreSQL on CentOS 7 and 8 Configure and Install PostgreSQL on CentOS 7...

Create and Install Self-Signed SSL Certificate on CentOS and Ubuntu

Create and Install Self-Signed SSL Certificate on CentOS and Ubuntu SSL certificate stands for...