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

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

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 CDN ? How Does a content delivery network Work?

I ntroduction. Latest Web sites and applications often need to provide   amount of static content to end users. This content includes images, style sheets, JavaScript, and video. The increase in the number of static assets and the increase grows the bandwidth usage increases page load time decreased, depending on the size of the user's search experience, and reduce the usable capacity of the server. Dramatically improving performance, reducing the page load time   reduce the bandwidth and infrastructure costs, you can implement a content delivery network,  And  CDN cache these assets at a set of servers that are geographically distributed. What is a CDN? Content delivery network is a group of servers distributed geographically optimized to provide static content to end users. While this static content can be almost any type of data, CDNs are most commonly used to deliver web pages and related files, streaming video and audio, and large softwar...
Post a Comment
Read more