☰
✕
✕

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.

Tag : CentOS phpMyAdmin
FAQ
Q
What are all the requiring repositories in phpMyAdmin?
A
The target system is updated with the required repositories. Install the LAMP server in the target system and press y to continue the installation process.

# apt-get install apache2 mysql-server php
Q
what are the features of phpmyadmin?
A
Features
• Intuitive web interface
• Support for most MySQL features:
o browse and drop databases, tables, views, fields and indexes
o create, copy, drop, rename and alter databases, tables,
Q
How can i install phpmyadmin on my system, it seem's no package available on centos?
A
Please install the EPEL repository before you try to install phpmyadmin, use the below command if the epel repo is not installed



yum install epel-release -y
Q
why phpmyadmin is needed for linuxmint?
A
The PostgreSQL Development Team has announced the latest version PostgreSQL 10. PostgreSQL is an open source object-relational database system. It is one of leading database server used for production servers. PostgreSQL allows us to execute stored procedures in various programming languages, like C/C++, Python, Java, Perl, Ruby and its own PL/pgSQL, which is similar to Oracle&rsquo s PL/SQL. It is so simple to install phpMyAdmin in LinuxMint 18.3 and this tutorial covers the ground on the same process.
Q
What is PhpMyAdmin?
A
PhpMyAdmin is a database management tool. It is a PHP application that manages MySQL or MariaDB database via web browsers and manages the user' s database. The frequently used operations are managing databases, tables, columns, relations, indexes, users, permission, etc.