The best and most commonly used tool to manage and administer mySQL and your databases is phpMyAdmin
. 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. 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.