MySQL Workbench provides several necessary tools in order to manage a MySQL environment. MySQL Workbench 5.2 is available for Windows, Mac and Linux platforms, it encapsulates three main functionalities:
1. SQL Development: Allows connecting to existing databases and run SQL Queries, SQL scripts, edit data and manage database objects. This functionality replaces the ones previously provided by the Query Browser stand-alone application.
2. Data Modeling: Helps to create and manage models, allows forward & reverse engineering and provides capability to compare and synchronize schemas
3. Server Administration: Helps to configure a database server, to setup user accounts and browse status variables and server logs
Let’s have a look deeper in each of those features: