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:
1 | 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:
1 | 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.
Cheers!