Medha Cloud Logo

What are the benefits of phpMyAdmin and How to Install and Configure phpMyAdmin on CentOS 7

Hi there,
Administration is a process packed with twists and turns, without proper knowledge and experience, it will be more complicated. But, in IT administration sector, we are blessed with a lot of tools that can ease out the daunting hassles, phpMyAdmin is one of that kind.
Today, let’s check more about phpMyAdmin and how it’s going to help us out.

Introduction:

phpMyAdmin is one of the most used open-source application for managing MySQL database. This is the free and open-source web-based application written in pHp. Also, to offer the ability to accomplish administrative tasks such as creating, editing, or deleting databases and managing users and permissions.

There are a few requirements that we have to ensure before heading to install phpMyAdmin in our systems. Let’s have a look at what all are they?

First, we go to the phpMyAdmin Installation, we should install LAMP stack on your server If you want LAMP installation below go with below URL:
https://medhahosting.com/how-to-install-lamp-in-centos/

Requirements:

    1. Dedicated/VPS Server
    2. Root access on the server
    3. Internet
    4. SSH  Access

Step 1: Configure the EPEL Repository

Phpmyadmin is not available in the CentOS repository, So, we will install and enable the EPEL repository.

yum -y install epel-release

Then, start the webserver and permit it to start upon server boot.

rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm

Step 2: Install phpMyAdmin

Once it is completed enableEPEL repository, after that we can proceed with the installation of phpMyAdmin

yum -y install phpmyadmin

Once completed, the installation included on Apache Configuration file has to put into place.
So we need to modify admin.conf, so open that file with your favorite text editor.

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

Present, this setup is configuring to deny access to any connection not being made from the server itself. So, we need to modify some lines to specify the IP address of your home Connection.

Require ip your_IP_address
Allow from your_IP_address
Require ip your_IP_address
Allow from your_IP_address

After successful modification, We will restart Apache web server.

systemctl restart httpd.service

Step 3: Access phpMyAdmin Web Interface

Then, go to your favorite web browser then open followed URL
http://IP_Adress/phpmyadmin
After that,  it opens the phpMyAdmin interface as shown in the below image.

That’s all. Thanks for reading, I hope you will find all the required information.
So, you learned to handle one of the most appreciated administration tools for MySQL and MariaDB.

Read https://medhahosting.com/benefits-nagios-install-centos-7/

Read How To Install & Configure Nagios In CentOS 7 Here

However, if you come across with any hassles that perplex you feel free to reach us at medhahosting
See you all with another amazing blog post.
Stay tuned.

Connect with Medha Cloud

Microsoft 365 Migration Form

I would like to send my contact information to MedhaCloud so that MedhaCloud can share additional information about products, services, thought leadership and invitations to flagship events with me by email. *

By submitting this form, I acknowledge that someone from MedhaCloud will contact me via email or phone to discuss my request.

Related Article

View All
chevron-down linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram