Install Phpmyadmin On Nginx Centos 7

Introduction

PhpMyAdmin is one of the most popular tools used to manage and administer a MySQL database. It is a web-based application and can be installed on a Linux-based operating system including CentOS 7. In this article, we will show you how to install and configure PhpMyAdmin on an Nginx web server on a CentOS 7 machine. This tutorial assumes that you already have an Nginx web server set up and running on your CentOS 7 server.

PhpMyAdmin is an open-source tool that makes it easy to manage and maintain MySQL databases. It is web-based, which means that it can be accessed from any web browser. PhpMyAdmin provides a graphical UI to interact with MySQL database and to manage database operations such as creating, dropping and modifying tables, columns, indexes and more.

Prerequisites

Before you can start, make sure that both Nginx and MySQL is installed and configured on your CentOS 7 machine. To do so, first log in to your server as the root user:

shell> sudo -i

Once you are logged in, you need to install Nginx on your server. To do so, you can use the following command:

shell> yum install nginx

Once Nginx is installed, you can then install MySQL on your machine. To do so, you can use the following command:

shell> yum install mysql-server

Once MySQL is installed, you can then configure it and start it. To do so, you can use the following command:

shell> systemctl start mysqld

Now that you have installed and configured both Nginx and MySQL on your server, you can now proceed to the next step of the guide.

Installing PHP

The next step is to install PHP. PhpMyAdmin requires PHP to run, so we will need to install it. To do so, you can use the following command:

shell> yum install php-fpm

Once PHP is installed, you can then configure it. To do so, first open the php.ini file:

shell> vi /etc/php.ini

Once you have opened the php.ini file, you need to edit the following directive:

curl.cainfo =

Replace the blank space after the equal sign with the path to the CA certificate file. For example:

curl.cainfo = /etc/pki/tls/certs/ca-bundle.crt

Once you have edited the directive, save and close the file. You can now start the PHP-FPM service. To do so, you can use the following command:

shell> systemctl start php-fpm

Installing PhpMyAdmin

PhpMyAdmin can be installed using the YUM package manager. To do so, run the following command:

shell> yum install phpmyadmin

The installation may take a few moments depending on your internet speed. Once it is done, you can then configure PhpMyAdmin. To do so, open the phpMyAdmin.conf file:

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

In this file, you need to edit the following directive to reflect the correct path to your phpMyAdmin installation directory:

alias /phpMyAdmin /usr/share/phpMyAdmin

Save and close the file. You can now start the Apache web server. To do so, you can use the following command:

shell> systemctl start httpd.service

Now you can access the PhpMyAdmin web interface from a web browser. To do so, open a web browser and go to the following URL:

http://Your_Server_IP_Address/phpMyAdmin

Securing PhpMyAdmin

Now that you have installed and configured PhpMyAdmin on your server, you should secure it. The most basic way to do this is by adding a password to the phpMyAdmin web interface. To do so, open the phpMyAdmin configuration file:

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

In this file, uncomment the following lines:

AuthType Basic
AuthName “phpMyAdmin Login”
AuthUserFile /etc/phpMyAdmin/htpasswd
Require valid-user

Here, you need to specify a username and password for the phpMyAdmin authentication. To do so, run the following command:

shell> htpasswd -c /etc/phpMyAdmin/htpasswd username

Here, replace username with the desired username. Now enter a password for the user. Once you have set the password, save and close the file. Now restart the Apache web server. To do so, you can use the following command:

shell> systemctl restart httpd

Configuring Nginx for PhpMyAdmin

Now you need to configure Nginx to serve the phpMyAdmin web interface. To do so, open the Nginx configuration file:

shell> vi /etc/nginx/conf.d/default.conf

In this file, add the following configuration:

server {
listen 80;
server_name 127.0.0.1;

location /phpMyAdmin {
root /usr/share/;
index index.php index.html index.htm;
try_files $uri /index.php?q=$uri&$args;
}
location ~ .php$ {
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
include fastcgi_params;
fastcgi_read_timeout 300;
fastcgi_param SCRIPT_FILENAME /phpMyAdmin/$fastcgi_script_name;
}
}

Here, make sure to replace 127.0.0.1 with your server’s IP address. Save and close the file. You can now restart Nginx. To do so, you can use the following command:

shell> systemctl restart nginx

You should now be able to access the phpMyAdmin web interface from a web browser. To do so, open a web browser and go to the following URL:

http://Your_Server_IP_Address/phpMyAdmin

Conclusion

In this article, we have shown you how to install and configure phpMyAdmin on an Nginx web server running on a CentOS 7 machine. We also showed you how to secure the phpMyAdmin interface and how to configure Nginx for it. We hope this article has been helpful and that you were able to install and use phpMyAdmin on your server.

FAQs

Q. What is PhpMyAdmin?

A. PhpMyAdmin is a free and open-source web-based database management tool written in PHP. It provides a graphical user interface (GUI) to interact with a MySQL database and is used to manage and administer MySQL databases.

Q. How do I install PhpMyAdmin on Nginx?

A. You need to first install and configure both Nginx and MySQL on your server. Once they are installed, you need to install and configure PHP. Then you