Table of Contents
- 16.1. MySQL Workbench Editions
- 16.2. Installing and Launching MySQL Workbench
- 16.3. Getting Started Tutorial
- 16.4. The Home Screen
- 16.5. SQL Development
- 16.6. Data Modeling
- 16.6.1. Open an Existing EER Model
- 16.6.2. Create new EER Model
- 16.6.3. Create EER Model from Existing Database
- 16.6.4. Create EER Model from SQL Script
- 16.6.5. Model Editor
- 16.6.6. EER Diagram Editor
- 16.6.7. Working with Models
- 16.6.8. Modeling Tutorials
- 16.6.9. Printing
- 16.6.10. MySQL Workbench Schema Validation Plugins (Commercial Version)
- 16.6.11. Customizing DBDoc Model Reporting Templates
- 16.7. Server Administration
- 16.8. Extending Workbench
- 16.9. Keyboard Shortcuts
- 16.10. MySQL Workbench FAQ
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: Enables 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: Enables 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: Enables 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 low cost.