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.
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.
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.