PhpMyAdmin is a free software written in PHP and is the most popular software used to manage tables and data in databases via the web. PhpMyAdmin supports various database operations such as MySQL and MariaDB. The intended tasks include managing databases, tables, columns, indexes, users, permissions, etc. All these tasks can be executed through a user-friendly user interface. However, even though phpMyAdmin has a user interface you can still execute MySQL statements and queries directly.
PhpMyadmin is very popular for managing databases because it can be accessed via a web browser. Apart from what was mentioned previously, we can also create, update, change, delete, import and export MySQL database tables using this software. You can also run MySQL queries, repair, optimize, check tables, and also run other database management commands. PhpMyAdmin can also be used to perform administrative tasks such as database creation and query execution.
CREATE DATABASE db_phpmyadmin;
CREATE USER 'adminrizwan'@'localhost' IDENTIFIED BY '123';
GRANT ALL PRIVILEGES ON *.* TO 'adminrizwan'@'localhost';
FLUSH PRIVILEGES;
EXIT;
