How to install and configure phpmyadmin on centos?

An open source tool that make MySql administration much easier is PhpMyAdmin.
PhpMyAdmin is a replacement for command-line utility and its web based interface. We can control and
manage our database administration with the help of PhpMyAdmin via a web browser easily.

In this article we will discuss how to install and configure phpMyAdmin on a CentOS.

Step 1 : Install a LAMP stack

We need to install Apache, MySQL, and PHP on our server.
# sudo yum install httpd mysql-server php php-mysql
Make sure the LAMP Stack is working and configured correct.

Step 2 : Enable EPEL Repository

Now we can install the PhpMyAdmin package. But this software is not available in the CentOS
default repositories. PhpMyAdmin is available in the EPEL repos (Extra Packages for Enterprise Linux).
phpMyAdmin is part of Extra Packages for Enterprise Linux (EPEL), which is a community repository of
non-standard packages for the RHEL distribution
We can add access to the EPEL repositories to our system by;
#sudo yum install epel-release

Step 3 : Set up apache with SSL

Installing PHP MyAdmin
Step 1 : Install phpMyAdin
# yum install phpmyadmin

A symbolic link from the document root to the phpMyAdmin installation location is created for each
virtual host that we would like to give access to your phpMyAdmin installation.
/usr/share/phpmyadmin
cd /var/www/example.com/public_html
sudo ln -s /usr/share/phpmyadmin
This will create a symbolic link named phpmyadmin in your document root.

Configure phpMyadmin

PhpMyAdmin is configured to only permit access from the localhost. In order to access it we have to add
the IP address of your computer. Just note the external IP address being used by your home or work
computer. Edit the configuration file located at /etc/httpd/conf.d/phpMyAdmin.conf, replacing the four
instances of 127.0.1.1 with the IP address of your home or work computer.

Open your browser and navigate to https://sample.com/phpmyadmin to test phpMyAdmin, . A username
and password box will be propted. Use the username “root” and the password you specified when you
installed MySQL. Also, we can log in using any MySQL user and password to retain their permissions.

ServerAdminz provides Outsourced 24/7 Technical Support, Remote Server Administration, Server Security, Linux Server Management, Windows Server Management and Helpdesk Management to Datacenters, Hosting companies and ISPs around the world. We specialize in Extended Server Security, Server Hardening, Support of Linux/UNIX/Windows servers, products and services.If you are looking for a server management service provider, you can contact us on sales@serveradminz.com or +1 (845) 271 7172.

ServerAdminz is a server support company specialized in Outsourced 24/7 Web Hosting Support, Remote Infrastructure Management, NOC, Cloud and Enterprise Security Services. With over 10+ of years of experience in working with major Data Centers and ISPs with 130+ experienced technicians, we continue to manage more than 49,000 servers from 85+ countries and has bagged 5 international awards.

If you have any queries on how to install and configure phpmyadmin on centos, share your thoughts and our representative will get back to you.[two_third last=”yes” spacing=”yes” center_content=”no” hide_on_mobile=”no” background_color=”” background_image=”” background_repeat=”no-repeat” background_position=”left top” border_position=”all” border_size=”0px” border_color=”” border_style=”” padding=”” margin_top=”” margin_bottom=”” animation_type=”” animation_direction=”” animation_speed=”0.1″ class=”” id=””]