Install Phpmyadmin Debian 10 Nginx

What is PhpMyAdmin?

PhpMyAdmin is a web-based administration tool for managing MySQL databases. It is one of the most popular applications in the Apache, Nginx, and Windows server stacks. This guide will show you how to install the latest version of PhpMyAdmin on a Debian 10 server using Nginx as a web server.

Prerequisites

Before proceeding with the installation, you will need to prepare your server for the installation. This guide assumes that you have already installed Debian 10 and Nginx on your server. You will also need to create a new database for phpMyAdmin and additionally, you will need to create a user account for the database. Additionally, you will need to install the php7.3-fpm and the php7.3-zip packages in order to complete the installation.

Install PhpMyAdmin

The first step is to download and install phpMyAdmin. To do so, use the following command:



$ wget https://files.phpmyadmin.net/phpMyAdmin/4.9.0.1/phpMyAdmin-4.9.0.1-all-languages.tar.gz

This command will download the latest version of phpMyAdmin to your server. Once the download is complete, extract the contents of the archive file:



$ tar -xzf phpMyAdmin-4.9.0.1-all-languages.tar.gz

Once the contents have been extracted, you can move them to the web root directory of your server. For an Nginx server, this is usually /var/www/html. You can use the following command to move the files:



$ mv phpMyAdmin-4.9.0.1-all-languages /var/www/html/phpMyAdmin

Move into the phpMyAdmin directory and copy the sample configuration file:



$ cd phpMyAdmin

$ cp config.sample.inc.php config.inc.php

Once the configuration file has been copied, open it in a text editor and replace the default settings with the settings for your database. The configuration file should contain the following values:



$cfg['Servers'][$i]['controluser'] = 'phpmyadmin';

$cfg['Servers'][$i]['controlpass'] = 'password';

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['port'] = '3306';

$cfg['Servers'][$i]['username'] = 'phpmyadmin';

$cfg['Servers'][$i]['password'] = 'password';

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';

$cfg['Servers'][$i]['relation'] = 'pma__relation;

$cfg['Servers'][$i]['table_info'] = 'pma__table_info';

$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';

$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';

$cfg['Servers'][$i]['column_info'] = 'pma__column_info';

$cfg['Servers'][$i]['history'] = 'pma__history';

$cfg['Servers'][$i]['recent'] = 'pma__recent';

$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';

$cfg['Servers'][$i]['tracking'] = 'pma__tracking';

$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';

$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';

Save the configuration file and exit your text editor.

Configure Nginx

The next step is to configure Nginx to serve the phpMyAdmin application. To do so, create a new Nginx server block configuration file in the /etc/nginx/conf.d directory:



$ vim /etc/nginx/conf.d/phpMyAdmin.conf

Then, paste the following configuration into the file and save it:



server {

    listen 80;

    server_name  phpmyadmin.example.com;

    root  /var/www/html/phpMyAdmin;

    index index.php;

    location / {

        try_files $uri $uri/ /index.php?$args;

    }

    location ~ .php$ {

        fastcgi_pass unix:/var/run/php/php7.3-fpm.sock;

        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;

        include fastcgi_params;

    }

}

Once the configuration file has been saved, test the syntax of the file and then restart Nginx for the changes to take effect:



$ nginx -s reload

Access phpMyAdmin

At this point, you can access the phpMyAdmin application from your web browser. To do so, open your favorite web browser and access the ip or name of the site running phpMyAdmin and you will be presented with the login page. Enter the admin username and password, and you will be logged into the phpMyAdmin interface.

Conclusion

In this guide, we have shown you how to install and configure phpMyAdmin on a Debian 10 server using Nginx as the web server. phpMyAdmin is a great tool for managing and administering MySQL databases from a web interface. We hope you have found this guide to be useful.

FAQs

Q. What version of phpMyAdmin is included in this guide?

A. This guide is for phpMyAdmin version 4.9.0.1.

Q. What do I need in order to install phpMyAdmin on my server?

A. You will need to have a Debian 10 server with Nginx already installed, as well as a database and user account for phpMyAdmin. Additionally, you will need to have the php7.3-fpm and php7.3-zip packages installed.

Q. Where can I find the configuration file?

A. The configuration file should be located in the phpMyAdmin directory. It is called config.inc.php.

Q. How do I access phpMyAdmin after it is installed?

A. Open a web browser and enter the ip or name of the site running phpMyAdmin. You should be presented with the login page and be able to log into phpMyAdmin with the admin username and password.

Thank you for reading this article. We hope it has helped you to understand how to install and configure phpMyAdmin on your Debian 10 server. For more information, please refer to our documentation and other resources.

Enable Memcached Nginx Debian 9 Enable Memcached Nginx Debian 9 Memcached Basics Memcached is a distributed memory caching system that greatly enhances the performance of network-based applications. It is a great tool that allows data…
How To Install Wordpress On Nginx How To Install Wordpress On Nginx Introduction If you’re looking to start your own website or blog, probably the easiest and most popular platform to choose is WordPress. WordPress is…
Setting Phpmyadmin Di Nginx Debian 9 Setting Phpmyadmin Di Nginx Debian 9 Introduction Nginx is a popular web server created for Unix-like operating systems like Debian. It is used for many web-related activities such as serving…
Ubuntu 18 Enable Php Mysql Nginx Ubuntu 18 Enable Php Mysql Nginx Introduction: What Is Ubuntu? Ubuntu is an open source operating system based on the Debian GNU/Linux distribution. Built around the Linux kernel and released…
Create Subdomain Nginx Debian 9 Server Create Subdomain Nginx Debian 9 Server Understanding Subdomain A subdomain is a subsection of a domain that a user can create to host one or more websites, usually for a…
Ubuntu Install Nginx Php7.2 Mysql Ubuntu Install Nginx Php7.2 Mysql What is Nginx? Nginx is an open source web server that is very popular for powering web applications such as WordPress and Drupal. It is…
Install Phpmyadmin Ubuntu 18.04 Nginx Install PhpMyAdmin Ubuntu 18.04 Nginx What is PhpMyAdmin? PhpMyAdmin is an open source software written in PHP that provides a graphical web-based interface for accessing and managing your MySQL or…
Install Mysql Pada Nginx Pada Ubuntu Install Mysql Pada Nginx Pada Ubuntu Overview of Nginx and Its Benefits Nginx is a web server, reverse proxy server, and mail proxy server application that is open-source and available…
Install Php Nginx Ubuntu 12.04 Install Php Nginx Ubuntu 12.04 Introduction Welcome to our guide on How to install PHP, Nginx & MySQL on Ubuntu 12.04 LTS. This guide should work on other Linux VPS…
Install Nginx Php Oci8 Pdo_Oci On Windows Install Nginx Php Oci8 Pdo_Oci On Windows Overview Nginx is a web server that is widely used for serving static content and as a reverse proxy for dynamic content. It…
Install Phpmyadmin For Nginx Debian 8 Install Phpmyadmin For Nginx Debian 8 Introduction The Nginx web server popularly known as Nginx is a lightweight web server written in C programming language. It is an open source…
Debian 502 Bad Gateway Nginx Fix Debian 502 Bad Gateway Nginx Fix What is a 502 Bad Gateway Error? A 502 Bad Gateway error is an HTTP status code displayed on your computer’s web browser when…
Can I Install Phpmyadmin In Nginx Can I Install Phpmyadmin In Nginx? PHPmyadmin is a web-based management tool for databases such as MySQL and MariaDB. It is a popular tool for web developers and database administrators…
Install Nginx Phpmyadmin Centos 7 Install Nginx Phpmyadmin Centos 7 What is Nginx? Nginx is a web server that is used in Linux-based operating systems such as Centos 7. It is designed to handle high-traffic…
How To Install Nginx Maridb 10 On Ubuntu 16.04 Lts How To Install Nginx Maridb 10 On Ubuntu 16.04 Lts Step 1 — Installing Nginx The first step in installing Nginx and MariaDB 10 on Ubuntu 16.04 is installing Nginx.…
Install Wordpress On Nginx Ubuntu Install Wordpress On Nginx Ubuntu Introduction WordPress is a popular open-source blogging platform and content management system (CMS). It is made to be used on the internet, and it is…
Install Laravel Nginx Ubuntu 18.04 Install Laravel Nginx on Ubuntu 18.04 Introduction In this tutorial, we will look at how to install Laravel with Nginx on an Ubuntu 18.04 server. Laravel is a powerful PHP…
Install Nginx Php Mysql Windows Server Install Nginx Php Mysql Windows Server Install Nginx Php Mysql Windows Server Installing Nginx Nginx is a web server that can be used to serve dynamic web pages as well…
Instal Nginx Centos Di Webuzo Instal Nginx Centos Di Webuzo Background Webuzo is a leading web server platform used by individuals and businesses alike. It supports a range of operating systems, including the popular CentOS…
How To Install Nginx Debian 9.7 How To Install Nginx Debian 9.7 Step 1: Setting Up the Server The first step in the installation of Nginx on Debian 9.7 is to set up the server. This…
Cara Cek Versi Php Nginx Debian Cara Cek Versi Php Nginx Debian Apa itu Nginx Debian? Nginx Debian adalah sebuah server web open source yang dirancang untuk cara yang fleksibel, mudah digunakan, dan simultan yang memungkinkan…
Install Mariadb Nginx Debian 9.7 Install Mariadb and Nginx on Debian 9.7 Overview of Installing MariaDB and Nginx on Debian 9.7 Installing MariaDB and Nginx on Debian 9.7 can be an essential step when setting…
Install Nginx Ubuntu 16.04 For Odoo Install Nginx Ubuntu 16.04 For Odoo Install Ubuntu Server 16.04 Before we can install Nginx for Odoo we need to install Ubuntu 16.04 on our server. Ubunutu 16.04 is still…
Deploy Laravel In Local Nginx Windows Deploy Laravel In Local Nginx Windows 1. Introduction To Nginx Nginx is a web server that is primarily used to handle web traffic. It is open source, meaning it is…
How To Debian Nginx Php How To Debian Nginx Php Step 1 – Setup Your VPS The first step to setting up your web server is getting your VPS (Virtual Private Server). This is usually…
Error Install Nginx Debian 9 Error Install Nginx Debian 9 What is Nginx Nginx is an open source web server software used to serve web requests. It has become one of the most popular web…
How To Install Phpmyadmin With Nginx On Windows 10 How To Install Phpmyadmin With Nginx On Windows 10 What Is Phpmyadmin? PhpMyAdmin is a popular open source tool used for managing MySQL databases, created written in PHP language. It…
Centos 6 Nginx Phpmyadmin Forbideen Centos 6 Nginx Phpmyadmin Forbidden Introduction CentOS 6, an open-source Linux operating system, is one of the most popular web server operating systems. It is considered to be a reliable…
Install Phpmyadmin On Nginx Centos 7 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…
How To Configure Nginx Debian How To Configure Nginx Debian Introduction to Nginx Debian Nginx is a web server and reverse proxy that is used to host websites and manage incoming traffic over the world…

RUMAH APLIKASI Kumpulan Aplikasi Android & iPhone

Install Phpmyadmin Debian 10 Nginx

Install Phpmyadmin Debian 10 Nginx

What is PhpMyAdmin?

Prerequisites

Install PhpMyAdmin

Configure Nginx

Access phpMyAdmin

Conclusion

FAQs

Q. What version of phpMyAdmin is included in this guide?

Q. What do I need in order to install phpMyAdmin on my server?

Q. Where can I find the configuration file?

Q. How do I access phpMyAdmin after it is installed?

Related Posts:

Leave a Reply Cancel reply