Chapter 16. MySQL Workbench

Table of Contents

16.1. MySQL Workbench Editions
16.2. Installing and Launching MySQL Workbench
16.2.1. Hardware Requirements
16.2.2. Software Requirements
16.2.3. Starting MySQL Workbench
16.2.4. Activation Procedure (Commercial Version)
16.3. Getting Started Tutorial
16.3.1. Administering a MySQL Server
16.3.2. Creating a Model
16.3.3. Adding Data to Your Database
16.4. The Home Screen
16.4.1. Workbench Central
16.4.2. Workspace
16.4.3. Workbench Application Minimum Window Size
16.4.4. Workbench Preferences
16.5. SQL Development
16.5.1. Open Connection to start Querying
16.5.2. New Connection
16.5.3. Edit Table Data
16.5.4. Edit SQL Script
16.5.5. Manage Connections
16.5.6. Manage DB Connections Dialog
16.5.7. SQL Editor
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.7.1. Server Administration
16.7.2. New Server Instance
16.7.3. Manage Data Import/Export
16.7.4. Manage Security
16.7.5. Manage Server Instances
16.7.6. Creating and Managing Server Instances
16.7.7. Server Administration and Configuration
16.8. Extending Workbench
16.8.1. GRT and Workbench Data Organization
16.8.2. Modules
16.8.3. Plugins
16.8.4. Adding a GUI to a Plugin using MForms
16.8.5. The Workbench Scripting Shell
16.8.6. Tutorial: Writing Plugins
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.

  1. 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.

  2. 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.

  3. 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.

Copyright © 2010-2020 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout