- 1 MySQL Workbench Introduction
- 2 MySQL Workbench Editions
- 3 Installing and Launching MySQL Workbench
- 4 Getting Started Tutorial
- 5 The Home Screen
- 6 SQL Development
- 7 Data Modeling
- 8 Server Administration
- 9 The Workbench Scripting Shell
- 10 Plugins
- 11 Keyboard Shortcuts
- 12 MySQL Workbench FAQ
- A MySQL Workbench Change History
MySQL Workbench provides a graphical tool for working with MySQL Servers and databases. MySQL Workbench fully supports MySQL Server versions 5.1 and above. It is also compatible with MySQL Server 5.0, but not every feature of 5.0 may be supported. It does not support MySQL Server versions 4.x. MySQL Workbench provides three main areas of functionality:
SQL Development
Data Modeling
Server Administration
This section provides a brief overview of this functionality.
SQL Development - Allows you to create and manage connections to database servers. As well as allowing you configure connection parameters, MySQL Workbench provides the capability to execute SQL queries on the database connections using the built-in SQL Editor. This functionality replaces that previously provided by the Query Browser stand-alone application.
Data Modeling - Allows you to create models of your database schema graphically, reverse and forward engineer between a schema and a live database, and edit all aspects of your database using the comprehensive Table Editor. The Table Editor provides easy-to-use facilities for editing Tables, Columns, Indexes, Triggers, Partitioning, Options, Inserts and Privileges, Routines and Views.
Server Administration - Allows you to create and administer server instances. This functionality replaces that previously provided by the MySQL Administrator stand-alone application.
MySQL Workbench is available in two editions. The Community Edition and the Standard Edition. The Community Edition is available free of charge. The Standard Edition provides additional Enterprise features, such as database documentation generation, at a low cost.
