This tutorial explains the process of installing one of the most popular open source application for managing MySQL databases – phpMyAdmin. phpMyAdmin is a free and open source web-based application written in PHP, used to easily manage MySQL databases through your favorite web browser instead of needing to use the MySQL command line interface.
PhpMyAdmin allows users to create, modify, rename, and delete databases, tables, or fields, execute SQL commands through the browser, import and export tables to a wide range of formats, create users and modify their privileges, and much more… Thanks to this tool, we will almost never need to use the MySQL command line again. We are going to install phpMyAdmin on a CentOS 8 VPS with Apache, MariaDB, and of course, PHP. Let’s begin.