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:

sudo apt-get install phpmyadmin

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:

cp -r /etc/phpmyadmin /var/www/yourdomain.com

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!