Latest

Tuesday, 6 August 2019

How to Install phpMyAdmin on CentOS 7

install-phpmyadmin-on-centos-7-lamp-server

phpMyAdmin is a free and open-source MySQL web interface. phpMyAdmin is developed in PHP and distributed under GNU GPL 2 license. phpMyAdmin is a portable web application and due to this reason, it become one of the most popular MySQL administration tools, especially for web hosting services.

Database administrators and developers uses phpMyAdmin to perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; managing users and permissions; or monitoring database instances.

In this article, we are installing phpMyAdmin on CentOS 7 based LAMP server.

This article is about step by step installation of phpMyAdmin on CentOS 7 based LAMP Server. Hence, it does not address the usage and applications of phpMyAdmin web interface. Therefore, if you are interested to learn more about phpMyAdmin then you should read Mastering phpMyAdmin 3.4 for Effective MySQL Management by Packt Publishing.

install-phpmyadmin-on-centos-7-lamp-server

Table of Contents:

 

phpMyAdmin System Requirements:

According to phpMyAdmin documentation following software are required by phpMyAdmin.

  • Database - MySQL / MariaDB 5.5 or later
  • Web Server - Apache, Nginx, IIS, etc.
  • PHP - PHP 7.1.3 or later

 

Environment Specification:

In this article, we are using the same CentOS 7 LAMP server, that we have configured in our previous post Install LAMP Stack on CentOS 7.

  • Hostname – phpmyadmin-01.example.com
  • IP Address – 192.168.116.191 / 24 
  • Operating System – CentOS 7.6

 

Installing phpMyAdmin Prerequisite - MariaDB Server:

Connect with phpmyadmin-01.example.com server using ssh as root user.

Required version of MariaDB 5.5 is available in CentOS 7 standard yum repositories. Therefore, we are installing it using yum command.

# yum install -y mariadb-server.x86_64

Start and enable MariaDB service.

# systemctl enable --now mariadb.service
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.

Configure and secure MariaDB service as follows.

# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none):
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] Y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] Y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] Y
 ... Success!

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] Y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] Y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

MariaDB database has been installed on our Linux server. The password of root user, that we have set here will be used later to login on phpMyAdmin web interface.

 

Installing phpMyAdmin Prerequisite - Apache HTTP Server:

Apache HTTP server is also available in CentOS 7 official yum repositories. Therefore, we are installing Apache web server using yum command.

# yum install -y httpd.x86_64

Start and enable httpd.service.

# systemctl enable --now httpd.service
Created symlink from /etc/systemd/system/multi-user.target.wants/httpd.service to /usr/lib/systemd/system/httpd.service.

Allow HTTP service in Linux firewall.

# firewall-cmd --permanent --add-service=http
success
# firewall-cmd --reload
success

Apache HTTP server is installed on our Linux server.

 

Installing phpMyAdmin Prerequisite - PHP Support:

phpMyAdmin requires PHP 7.1.3 or later that is not available in CentOS 7 official yum repositories. Therefore, we have to install a third party yum repository for installing our required version of PHP.

We will use Remi yum repository to install PHP 7.1.3. But first, we have to install EPEL (Extra Packages for Enterprise Linux) because it is required by Remi yum repository.

# yum install -y epel-release.noarch

Install Remi yum repository as follows.

# rpm -ivh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
Retrieving http://rpms.remirepo.net/enterprise/remi-release-7.rpm
warning: /var/tmp/rpm-tmp.wO9bgO: Header V4 DSA/SHA1 Signature, key ID 00f97f56: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:remi-release-7.6-2.el7.remi      ################################# [100%]

Build cache for new yum repositories.

# yum makecache fast
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
epel/x86_64/metalink                                     | 5.8 kB     00:00
 * base: ftp3.isra.edu.pk
 * epel: mirror.xeonbd.com
 * extras: ftp3.isra.edu.pk
 * remi-safe: rpms.remirepo.net
 * updates: ftp3.isra.edu.pk
base                                                     | 3.6 kB     00:00
epel                                                     | 5.3 kB     00:00
extras                                                   | 3.4 kB     00:00
remi-safe                                                | 3.0 kB     00:00
updates                                                  | 3.4 kB     00:00
(1/4): epel/x86_64/group_gz                                |  88 kB   00:00
(2/4): remi-safe/primary_db                                | 1.6 MB   00:03
(3/4): epel/x86_64/primary_db                              | 6.8 MB   00:15
(4/4): epel/x86_64/updateinfo                              | 997 kB   00:35
Metadata Cache Created

Install PHP 7.2 and relevant packages.

# yum install -y php72-php php72-php-mysqlnd php72-php-gd php72-php-xml php72-php-mbstring

PHP 7.2 and relevant packages has been installed on our Linux server.

We have successfully configured a CentOS 7 based LAMP server.

 

Installing phpMyAdmin on CentOS 7 LAMP Server:

phpMyAdmin 4.4 is available in EPEL yum repository. However, phpMyAdmin 5 has been released and available for download on their website.

If you want to use some exclusive features of phpMyAdmin 5 then you have to install it. Otherwise, phpMyAdmin 4.4 will serve the purpose of database administration as well.

Install phpMyAdmin using yum command.

# yum install -y phpmyadmin

phpMyAdmin created it's configuration in Apache HTTP server at /etc/httpd/conf.d/phpMyAdmin.conf.

By using Apache Access Control, phpMyAdmin only allows access by localhost in its default configurations.

Therefore, we need to edit it to allow access by other network systems.

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

In following directive, Add a configuration below as highlighted in yellow color.

<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8

   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       Require ip 127.0.0.1
       Require ip ::1
       Require ip 192.168.116
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

Restart httpd.service to apply changes.

# systemctl restart httpd.service

Browse URL http://phpmyadmin-01.example.com/phpmyadmin in client's browser.

01-phpmyadmin-login-page

Login using MariaDB database credentials. We are login as root user here.

02-phpmyadmin-dashboard

We are now at the phpMyAdmin dashboard.

The only databases are visible here on which user has permissions.

Since, root is the super-user of MariaDB server, therefore, it can see all databases on the server.

phpMyAdmin has been installed on our CentOS 7 LAMP server.

If you find this article useful? Don't you mind support us by Buy Me A Coffee


No comments:

Post a Comment

© 2022 CentLinux. All Rights Reserved.