MySQL-Front, now ofiically called SQL-Front, is a front-end interface for the popular MySQL database. It allows the user to manage and administer databases from an easy to use Windows interface, rather than via the command line.
Main advantages of MySQL-Front or SQL-Front
Because MySQL-Front is a real application, it can offer a more refined user-interface than is possible with systems built on PHP and HTML (for example phpMyAdmin). Response is immediate, as there is no delay of reloading HTML-pages!
Data is presented in a table with resizable column-widths and sorting capability.
If the provider allows it, SQL-Front can make direct contact with the database.
Because of the intuitive interface, database structure can be created by clicking with a mouse. But, the tool still allows for manual running of queries and such. Therefore, it suits well to designers with only a basic grasp of databases, as well as to SQL gurus.
Supported functions by MySQL-Front or SQL-Front
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,
- copy tables to new table-names,
- manage users,
- flush Host/Logs/Privileges/Tables,
- and more.
You can also use MySQL-Front to write SQL-queries with syntax-highlighting and export and import data from ODBC-datasources.
Download MySQL-Front or SQL-Front