How to Install phpMyAdmin

phpMyAdmin provides a web interface for managing MySQL and MariaDB databases.

Install

apt install phpmyadmin -y

Select Apache or Nginx when prompted. Say yes to configuring with dbconfig-common.

For Nginx

Create a symlink:

ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin

Access

Visit http://YOUR_IP/phpmyadmin

Security

• Restrict access by IP in your web server config
• Use a non-standard URL (rename the symlink)
• Enable 2FA in phpMyAdmin settings
• Use HTTPS