How to install phpMyAdmin on Debian

What is phpMyAdmin?

phpMyAdmin is a free and open source tool written in PHP used for administration of MySQL with the use of a web browser. You can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions with it.

We?ll install phpMyAdmin with nginx on Debian.

Prerequisites for phpMyAdmin Installation:

As we?ll install phpMyAdmin with nginx on Debian, you?ll need a Debian based webserver running with nginx, PHP & MySql installed in it.

Install phpMyAdmin

To install phpMyAdmin on Debian type the following command on terminal:

This command will install phpMyAdmin on your server. Now, we?ll need to make this accessible by our webserver.

Make phpMyAdmin Accessible

The default installation directory for phpMyAdmin is /etc/phpmyadmin. We?ll need to copy this directory to our domain root. Type the following command on your terminal:

Replace yourdomain.com with your actual domain name.

Now, you can access phpMyAdmin with your browser by visiting yourdomain.com/phpmyadmin.

You should get phpMyAdmin login page.

phpMyAdmin Login Page

Enter the login credentials you set while installing MySql & Keep using phpMyAdmin.

You might want to enable HTTP authentication for your phpMyAdmin installation directory. Learn how to enable HTTP authentication on nginx.

Cheers!