phpMyAdmin is a free web application that provides a convenient GUI for working with the MySQL database management system. It is the most popular MySQL administration tool that is used by millions of users worldwide and has won numerous awards and honors.
Written in PHP, it has all common functions that you may need when developing a MySQL-based application or website. It also gave birth to several similar products, for example phpPgAdmin which provides similar functionality for the PostgreSQL DBMS.
You can use phpMyAdmin for Windows or almost any other operating system ever existed. It can export and import database created and managed by MySQL DBMS, as well as work with some other data formats.
The list of supported formats includes SQL, CVS, CodeGen, CVS for Microsoft Excel, Microsoft Word 2000, JSON, LaTeX, MediaWiki Table, OpenDocument Spreadsheet, OpenDocument Text, PDF, PHP Array, Texy! Text and YAML data types.
The tool is very simple to set up and use. It is usually installed on the same computer with MySQL database, so all commands are executed very quickly and don’t rely on network connectivity.