Introduction to phpMyAdmin on Linux
phpMyAdmin is an open-source web tool that allows managing MySQL and MariaDB servers via an intuitive graphical interface. In Linux environments, where most database servers are deployed, phpMyAdmin has become an essential component for administrators and developers who prefer to avoid the command line for routine tasks. This article covers everything from basic installation to security best practices and advanced tips to get the most out of phpMyAdmin on a Linux server.
Installation on Ubuntu and Debian
On Debian-based distributions, installation is as simple as running:
sudo apt update
sudo apt install phpmyadmin
During the process, the package will ask for the web server you want to configure (apache2 or lighttpd) and whether you want dbconfig-common to configure phpMyAdmin’s internal database. Select apache2 and allow dbconfig-common to create the database and the phpmyadmin user. After installation, restart Apache with:
sudo systemctl restart apache2
You can then access the tool at http://your-server/phpmyadmin and authenticate with a MySQL user that has sufficient privileges.
Installation on CentOS, RHEL, and Fedora
This post is also available in ESPAÑOL.