How to install PhpMyAdmin on CentOS 6

How to install PhpMyAdmin on CentOS 6

PhpMyAdmin is open source database management tool. It is a PHP application that manages MySQL or MariaDB database via web browsers and manage the user' s database. The frequently used operations are managing databases, tables, columns, relations, indexes, users, permission, etc. This tutorial explains the installation procedure of PhpMyAdmin on CentOS 6.

Installation procedure

Before starting the installation procedure, install the EPEL Repository which is a community repository of non-standard packages for the RHEL distribution by running the following command.

[root@linuxhelp1]#  yum install epel-release

Next update the required repositories by executing the following command.

[root@linuxhelp1]#  yum update

Before installing the PhpMyAdmin, a LAMP environment must be set up in the target machine. The LAMP server is installed in the system by running the following command to install it and press y to continue.

[root@linuxhelp1]#  yum install httpd mysql-server php  -y
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: centos.excellmedia.net
 * extras: mirror.ehost.vn
 * updates: centos.excellmedia.net
base                                                     | 3.7 kB     00:00   
extras                                                   | 3.4 kB     00:00    
updates                                                  | 3.4 kB     00:00    
Package php-5.3.3-49.el6.x86_64 already installed and latest version
Resolving Dependencies
-->  Running transaction check
--->  Package httpd.x86_64 0:2.2.15-53.el6.centos will be updated
--->  Package httpd.x86_64 0:2.2.15-59.el6.centos will be an update
-->  Processing Dependency: httpd-tools = 2.2.15-59.el6.centos for package: httpd-2.2.15-59.el6.centos.x86_64
--->  Package mysql-server.x86_64 0:5.1.73-8.el6_8 will be installed
-->  Processing Dependency: mysql = 5.1.73-8.el6_8 for package: mysql-server-5.1.73-8.el6_8.x86_64
.
.
.
.
.
.
  Verifying  : httpd-2.2.15-53.el6.centos.x86_64                                                                                                                                                      10/10
Installed:
  mysql-server.x86_64 0:5.1.73-8.el6_8                                                                                                                                                                      
Dependency Installed:
  mysql.x86_64 0:5.1.73-8.el6_8                                    perl-DBD-MySQL.x86_64 0:4.013-3.el6                                    perl-DBI.x86_64 0:1.609-4.el6                                  
Updated:
  httpd.x86_64 0:2.2.15-59.el6.centos                                                                                                                                                                       
Dependency Updated:
  httpd-tools.x86_64 0:2.2.15-59.el6.centos                                                                mysql-libs.x86_64 0:5.1.73-8.el6_8                                                               
Complete!

Next, execute the following command to install MySQL secure installation with password protection.

[root@linuxhelp1]# mysql_secure_installation
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
.
.
.

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

The LAMP package has been installed successfully. Start the Apache and MySQL service by running the following commands.

[root@linuxhelp1]# service httpd start

The Apache and MySQL services are running without any glitches. Now install the PhpMyAdmin package and press y to continue with the installation procedure.

[root@linuxhelp1]#  yum install phpmyadmin -y

Open the browser and enter the target system IP address along with the PhpMyAdmin file to run the application. Now log in to PhpMyAdmin with the required database username and password.

The PhpMyAdmin is running successfully and now the user can manage the databases.

The installation is complete. It was an easy installation procedure, Wasn' t it? PhpMyAdmin can be used to quickly create or delete databases and even import and export the databases.