Skip to main content

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. 
Labels:

Comments

Post a Comment

Popular posts from this blog

How to Speedup your WordPress site with Amazon CloudFront.

Introduction A WordPress performance is quite excellent . The number of WordPress plugins to handle performance is such evidence. But the easiest way to improve your user experience is to accelerate the entire WordPress website using CloudFront. This will help you not only improve site response time reduces the necessary infrastructure, reducing the load on the Web server, so you can reduce the total cost of the infrastructure works WordPress. CloudFront is actually a site can greatly help your site to respond to unexpected load when gained popularity. Today this post is to clarify the method of providing a reasonable standard configuration on the WordPress website or blog. How does CloudFront help? Amazon CloudFront is to improve the user's experience accessing the Web site in several ways: 1.  Anycast DNS is to ensure that customers are routed to the nearest edge location. 2.  The cached content is available to users at the edge positi...
100 comments
Read more

What is a cron in Linux?

Information The cron utility is a Linux program that schedules a command or script on  Linux server  or system  to run automatically at a specific date  and time . C ron jobs include three  Elements: The action   or the output of the script . It’s depending on what the script). The cron script to be executed or called The command executes the script on a recurring basis. It’s usually defined in web host panel. In VPS and Dedicated Server  run a cron job as often as you wish but In Shared and Reseller   DO NOT run a cron job more frequently than every 15 minutes (it’s  limitation of cron ). Timing  patent of cron Five  part of the cron job 1.  M inute  2. H our  3. D ay of month  4. M onth  5. D ay of week Examples: This will run on Sunday , every hour (24 times in one day, but only on Sundays ): 0 * * * 1 command E very 5 minutes: */5 * * * * comm...
1 comment
Read more

Install and Use GNU Nano Text Editor

How to Install  Nano  Text Editor The procedure depends on the the operating system you are running.   Specifically, some of them as of now accompany the Nano text editorial manager pre-installed.   Installing Nano on Debian/Ubuntu   E xecute the following command:   sudo apt-get install nano   Installing Nano on  CentOS/RHEL   E xecute this command:   yum install nano How to Use Nano Text Editor   Open and close files command to open the editor is: nano filename To open a file in another directory use: nano /path/to/directory/test.txt To save the changes made in the file and continue editing press  CTRL + O . To exit the editor, press CTRL + X . If changes have been made to the current open file, it will ask if it will save them or else it will come out immediately. Enter y for yes or n for no and then press ENTER. Editing Text In order to  se...
Post a Comment
Read more