PhpMyAdmin with Apache on CentOS

Introduction

PhpMyAdmin is an open source management tool for MySQL and MariaDB. Web application written mainly in PHP, has become one of the most popular MySQL management web tool. 

Features of phpMyAdmin

- Import and export database in a variety of formats
- Create, delete, rename databases and user accounts
- Manage databases privileges
- Execute SQL-queries
And many more  

Before Installation Requirements 

Sudo user access(Allow to run Linux commands).
Need LAMP (Linux, Apache, MySQL, and PHP) on your CentOS server.

phpMyAdmin Install process.

1. Install EPEL repository.


sudo yum install epel-release

2. Install phpMyAdmin.

With this command they auto installed all phpMyAdmin dependency with latest version of phpMyAdmin.

sudo yum install phpmyadmin


Configuration of phpMyAdmin.

Open Apache configuration file for phpMyAdmin 

sudo nano /etc/httpd/conf.d/phpMyAdmin.conf

And add below changes

# Apache 2.4
               Require ip IP_address
               Require ip 127.0.0.1
               Require ip ::1

# Apache 2.2
               Order Deny,Allow
               Deny from All
               Allow from IP_address
               Allow from 127.0.0.1
               Allow from ::1

Save and close (Note : IP_address is the your actual system IP address)

Restart the Apache web server

sudo systemctl restart httpd


Accessing your phpMyAdmin open web browser and run URL

https://IP_address/phpmyadmin



Finally, You successfully installed phpMyAdmin with Apache on CentOS.

Thanks for being here. 
PhpMyAdmin with Apache on CentOS PhpMyAdmin with Apache on CentOS Reviewed by Raj on October 15, 2018 Rating: 5

No comments:

Powered by Blogger.