How do i start phpmyadmin in nginx?

PhpMyAdmin installation on Nginx

Would you like to learn how to install PhpMyAdmin on a computer running Ubuntu Linux? In this tutorial, we are going to install and configure PhpMyAdmin using the Nginx server on a computer running Ubuntu Linux.

• Ubuntu 18
• Ubuntu 19
• Ubuntu 20
• Nginx 1.18.0
• PhpMyAdmin 4.9.5

Equipment list

The following section presents the list of equipment used to create this tutorial.

As an Amazon Associate, I earn from qualifying purchases.

Related tutorial - MySQL

On this page, we offer quick access to a list of tutorials related to MySQL.

Tutorial PhpMyAdmin - MySQL installation

Install the MySQL database service.

Access the MySQL service command-line.

Set a password to the MySQL root user.

In our example, we set the Mysql password: Kamisama123

Try to access the MySQL service using the new password.

Create a database named phpmyadmin.

Create a Mysql user account named PMA

In our example, we set the Mysql password: Kamisama123

Grant the PMA user account permission over the database named PHPMYADMIN.

Download the PhpMyAdmin installation package.

Import the PhpMyAdmin's database template using the account named PMA.

You have finished the PhpMyAdmin database installation.

Tutorial PhpMyAdmin - Nginx installation

Install the Nginx web server and all the required packages.

Install other PHP modules.

Find the location of the PHP configuration file on your system.

Edit the configuration file named: PHP.INI.

Your PHP version may not be the same as ours.

Your PHP configuration file location may not be the same as ours.

Enable and configure the following items of the PHP configuration file.

Set the correct timezone to your location.

Edit the Nginx configuration file for the default website.

Enable the PHP support for Nginx.

Here is the original file, before our configuration.

Here is the new file with our configuration.

Verify if your Nginx configuration file has no error.

Here is the command output.

Restart the Nginx service.

You have finished the Nginx service installation with PHP support.

Tutorial PhpMyAdmin - Installation on Ubuntu

Move the PhpMyAdmin directory to the Nginx root directory.

Create the list of required directories.

Set the correct permissions.

Create the PhpMyAdmin's configuration file.

Edit the configuration file.

Enable and configure the following items of the configuration file.

Use the following command to generate the random key used on the parameter named: BLOWFISH_SECRET

Open your browser and enter the IP address of your web server plus /phpmyadmin.

In our example, the following URL was entered in the Browser:

• http://172.31.8.195/phpmyadmin

The PhpMyAdmin login screen will be displayed.

On the Login screen, enter the MySQL's ROOT account information.

After a successful login, The PhpMyAdmin dashboard will be displayed.

Congratulations! You have finished the installation of PhpMyAdmin.

Tutorial PhpMyAdmin - Basic authentication

The PhpMyAdmin software provides a direct interface to the MySQL service.

We are going to configure an extra layer of authentication to protect the initial access to PhpMyAdmin.

Create the password file and add the first user account.

The system will request you to enter the password to the new user account.

Here is the file content.

To create additional user accounts, use the following command.

Edit the Nginx configuration file for the default website.

Create a new location named PHPMYADMIN.

Here is the file after our configuration.

Restart the Nginx service.

Open your browser and enter the IP address of your web server plus /phpmyadmin.

In our example, the following URL was entered in the Browser:

• http://172.31.8.195/phpmyadmin

The Nginx server will require you to perform the user authentication.

After a successful login, The PhpMyAdmin login screen will be presented.

After a successful login, the PhpMyAdmin dashboard will be displayed.

Congratulations! You have finished the installation of PhpMyAdmin.

Related Posts