phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.
Ranked in these QuestionsQuestion Ranking
Pro Available in most hosting services
Because of its portability, popularity and robustness phpMyAdmin is included in most hosting services that support the LAMP stack.
phpMyAdmin can run in a web browser, this makes it a very portable tool because it can be run on any computer and on any OS as long as it has a web browser installed.
Pro Easy to edit
Editions can be performed over a result table just by clicking the desired field.
Pro Complete functionality
phpMyAdmin is complete as far as features and functionality go. You can even build a full website without knowing any MySQL.
Pro Easy installation
The installation process itself is very simple, you need to have PHP and MySQL installed on your server, extract the files to a specified directory and run the install script. If you get stuck somewhere there's a lot of help online. The official wiki is very good too as far as the installation goes.
Con Confusing interface
It may take some time to get used to it.
Con No schema visualization
Con No code higlighting
phpMyAdmin does not have any code highlighting or auto-completion capabilities, unlike other options.