MySQL-Front

MySQL-Front is a practical and reliable piece of software especially designed for users who need to manage and organize MySQL databases, queries, statements, processes and variables.

After you launch the application for the first time, you are required to connect to a new database. All you have to do is to specify the host and the port number, choose the connection type and set login information. Afterward, you are able to choose the database you want. You can add a new connection by accessing the File menu and manage all your connected databases, as well as add new ones.

The main window of MySQL-Front is very simple and easy to work with. By navigating to the left panel you are able to view all the available databases, used processes and variables.

The ‘Object Browser’ tab enables you to view the structure of the database along with tables, fields, indices and comments. The right-click menu enables you to rename the selected table, add a new field, foreign key or trigger, as well as import ODBC tables.

By using the ‘Query Builder’ option (which can be accessed from the View menu) you are able to view all the available tables in the current database and connect them through primary keys. This way, you can easily map them, define source database objects and derived tables and perform INNER JOIN statements. The main purpose of such statements is to gather and to display data from multiple tables.

In order to add new tables you can easily drag and drop them from the navigator or simply right-click on the main window and choose the ‘Add Table’ option.

In case you want to write multiple SQL statements and execute them directly, you can navigate to the ‘SQL Editor’ section. You are able to run as many scripts as you want and view all the available data in the bottom pane of the application.

To conclude, MySQL-Front offers you an intuitive and user-friendly environment from where you can manage and organize your MySQL databases and tables effortlessly.