SQLyog Community Edition
SQLyog Community Edition is a powerful program that enables you to work with MySQL databases using a visual interface. If you are not used to the command line interface, this tool turns the MySQL database management into an easier job.
In order to use this software you need to install the MySQL server and to provide the application with the connection settings. After you have completed these tasks and you are connected to the server you can get to work.
You can create new databases, tables and queries by using the menus and the buttons from the main window. The program stores all the commands in the history tab in order to review the code lines later. Every element of the database can be edited using the visual interface. You need to write code only in the Query Editor that allows you to create new queries that can be saved as SQL files.
To back up a database or to transfer the data and the structure from one database to another are tasks that can be performed with just a few clicks. This allows you to shorten the time required to perform certain actions and to increase your productivity.
The program is able to connect multiple servers at the same time allowing you to transfer data between them. You can also run multiple queries at the same time and stop the execution of the ones that run for a longer time. You can also take advantage of the templates available in the application to create queries, functions or tables.
The interface of the program is easy to understand and all its functions are easy to access. The menus are intuitive and allow you to quickly access the most frequently used commands. The editor colors and the fonts can be changed in order to make the code more visible. You can also change the colors of the Object Browser to personalize each connection.
SQLyog includes multiple tools that can be used to increase your productivity such as the Database Synchronization Wizard and the ability to schedule backups or other jobs. Unfortunately they are not available in the Community Edition and need to be purchased separately.
Although it is designed for power users and developers SQLyog can also be used by beginners. The application features an extensive Help file that allows the beginner to learn a thing or two about SQL database management.