MySQL-Front is a front-end interface for the popular MySQL database. It allows you to manage and administer your databases from an easy to use Windows interface, rather than via the command line. It supports many functions, including create/drop databases create/drop tables, edit/add/delete fields, edit/insert/delete records, edit BLOBs and MEMOs with Bitmap/GIF/JPEG-Support, view and kill other user-processes execute (large) SQL-scripts, view advanced table-properties, replication, copy tables to new table-names, manage users, flush Host/Logs/Privileges/Tables and much more. You can also use mySQL-Front to write SQL-queries with syntax-highlighting and export and import data from ODBC-datasources.
Visual development system for MySQL database design, modeling, and creation.
Manages both on-premises and cloud databases such as Amazon RDS, Amazon Aurora.
Comments (7)
- .SQL exported data is not 100% compatible with phpMyAdmin. MySQL-Front exports ## comments, while hpMyAdmin expects -- comments,
so you will get warnings, when trying to import MySQL-Front exported data into phpMyAdmin.
- When exporting to .SQL format, latin characters (accented i,e,o,u) in my database were converted to question marks ?.
This shouldn't happen. I think this is a bug.
Pros: Easy to use.
Cons: Not a offline Database editor. You can't import .sql file, edit the database, and then export .sql file, in an offline mode.
I use Nils (R.I.P. mny friend) mysql-front for about 15 years and still love it!