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

Apt-fast for Increasing Download Speed while Installing and Updating Packages Ubuntu/Debian [Beginners Guide]

Have you ever experienced slow download speed when downloading or updating packages in Ubuntu even when your network connection is running fine? You encounter this issue especially when updating and installing packages for the first time after installing a new Ubuntu/Debian OS. However, there is a way to get around this by speeding up the download speed using apt-fast command in Linux. Apt-fast is a shell script wrapper for “apt-get” and “aptitude” that uses the power of either  axel  or  aria 2  download managers to accelerate the download process. It improves download performance by downloading packages simultaneously in parallel with multiple packages per connection. In this article, we will walk through some steps to install apt-fast in order to accelerate the update and downloading process in Ubuntu. We will use Ubuntu 18.04 LTS for describing the procedure mentioned in this article.   Step 1: Installing prerequisites We need to install...
Post a Comment
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