MySQL Workbench

Table of Contents     [+/-]

Preface and Legal Notice

1. MySQL Workbench Introduction

2. MySQL Workbench Editions

3. Installing and Launching MySQL Workbench     [+/-]

3.1. Hardware Requirements

3.2. Software Requirements

3.3. Starting MySQL Workbench     [+/-]

3.3.1. Installing MySQL Workbench on Windows

3.3.2. Launching MySQL Workbench on Windows

3.3.3. Uninstalling MySQL Workbench on Windows

3.3.4. Installing MySQL Workbench on Linux

3.3.5. Launching MySQL Workbench on Linux

3.3.6. Uninstalling MySQL Workbench on Linux

3.3.7. Installing MySQL Workbench on Mac OS X

3.3.8. Launching MySQL Workbench on Mac OS X

3.3.9. Uninstalling MySQL Workbench on Mac OS X

4. Getting Started Tutorial     [+/-]

4.1. Administering a MySQL Server

4.2. Creating a Model

4.3. Adding Data to Your Database

5. The Home Window     [+/-]

5.1. Workbench Central

5.2. Workspace

5.3. Workbench Application Minimum Window Size

5.4. Workbench Preferences     [+/-]

5.4.1. The General Tab

5.4.2. The Administrator Tab

5.4.3. The SQL Editor Tab

5.4.4. The Model Tab

5.4.5. The MySQL Tab

5.4.6. The Diagram Tab

5.4.7. The Appearance Tab

6. SQL Development     [+/-]

6.1. Open Connection to Start Querying

6.2. New Connection

6.3. Edit Table Data

6.4. Edit SQL Script

6.5. Manage Connections

6.6. Manage DB Connections Dialog     [+/-]

6.6.1. The Password Storage Vault

6.6.2. Standard TCP/IP Connection

6.6.3. Local Socket/Pipe Connection

6.6.4. Standard TCP/IP over SSH Connection

6.7. SQL Editor     [+/-]

6.7.1. Main Menu

6.7.2. Toolbar

6.7.3. SQL Query Panel

6.7.4. Main Tabsheets

6.7.5. Sidebar

7. Data Modeling     [+/-]

7.1. Open an Existing EER Model

7.2. Create New EER Model

7.3. Create EER Model from Existing Database

7.4. Create EER Model from SQL Script

7.5. Model Editor     [+/-]

7.5.1. Modeling Menus

7.5.2. The Toolbar

7.5.3. EER Diagrams

7.5.4. The Physical Schemata Panel

7.5.5. The Schema Privileges Panel

7.5.6. The SQL Scripts Panel

7.5.7. The Model Notes Panel

7.5.8. The History Palette

7.5.9. The Model Navigator Panel

7.5.10. The Catalog Tree Palette

7.5.11. The Layers Palette

7.5.12. The Properties Palette

7.6. EER Diagram Editor     [+/-]

7.6.1. The Vertical Toolbar

7.7. Working with Models     [+/-]

7.7.1. Creating Tables

7.7.2. Creating Foreign Key Relationships

7.7.3. Creating Views

7.7.4. Creating Routines and Routine Groups

7.7.5. Creating Layers

7.7.6. Creating Notes

7.7.7. Creating Text Objects

7.7.8. Creating Images

7.7.9. Reverse Engineering

7.7.10. Forward Engineering

7.8. Modeling Tutorials     [+/-]

7.8.1. Importing a Data Definition SQL Script

7.8.2. Using the Default Schema

7.8.3. Basic Modeling

7.8.4. Documenting the sakila Database

7.9. Printing     [+/-]

7.9.1. Printing Options

7.10. MySQL Workbench Schema Validation Plugins (Commercial Version)     [+/-]

7.10.1. General Validation

7.10.2. MySQL-Specific Validation

7.11. The DBDoc Model Reporting Dialog Window (Commercial Version)

7.12. Customizing DBDoc Model Reporting Templates     [+/-]

7.12.1. Supported Template Markers

7.12.2. Creating a Custom Template

8. Server Administration     [+/-]

8.1. Server Administration

8.2. New Server Instance

8.3. Manage Data Import/Export

8.4. Manage Security

8.5. Manage Server Instances

8.6. Creating and Managing Server Instances     [+/-]

8.6.1. New Server Instance Wizard

8.6.2. Manage Server Instances Dialog

8.7. Server Administration and Configuration     [+/-]

8.7.1. The Startup Tab

8.7.2. The Configuration Tab

8.7.3. The Accounts Tab

8.7.4. The Connections Tab

8.7.5. The Variables Tab

8.7.6. The Data Dump Tab

8.7.7. The Logs Tab

9. Extending Workbench     [+/-]

9.1. GRT and Workbench Data Organization

9.2. Modules

9.3. Plugins

9.4. Adding a GUI to a Plugin Using MForms

9.5. The Workbench Scripting Shell     [+/-]

9.5.1. Exploring the Workbench Scripting Shell

9.5.2. The Shell Window

9.5.3. The Globals, Classes, and Modules Tabs

9.6. Tutorial: Writing Plugins

10. Keyboard Shortcuts

11. MySQL Utilities     [+/-]

11.1. Introduction     [+/-]

11.1.1. Introduction to MySQL Utilities

11.1.2. Connection Parameters

11.2. Commands     [+/-]

11.2.1. mysql.utilities.command.grep — Search Databases for Objects

11.2.2. mysql.utilities.command.proc — Search Processes on Servers

11.3. Manual Pages     [+/-]

11.3.1. mut - MySQL Utilities Testing

11.3.2. mysqldbcompare - Compare Two Databases and Identify Differences

11.3.3. mysqldbcopy - Copy Database Objects Between Servers

11.3.4. mysqldbexport - Export Object Definitions or Data from a Database

11.3.5. mysqldbimport - Import Object Definitions or Data into a Database

11.3.6. mysqldiff - Identify Differences Among Database Objects

11.3.7. mysqldiskusage - Show Database Disk Usage

11.3.8. mysqlindexcheck - Identify Potentially Redundant Table Indexes

11.3.9. mysqlmetagrep - Search Database Object Definitions

11.3.10. mysqlprocgrep - Search Server Process Lists

11.3.11. mysqlreplicate - Set Up and Start Replication Between Two Servers

11.3.12. mysqlrplcheck - Check Replication Prerequisities

11.3.13. mysqlrplshow - Show Slaves for Master Server

11.3.14. mysqlserverclone - Clone Existing Server to Create New Server

11.3.15. mysqlserverinfo - Display Common Diagnostic Information from a Server

11.3.16. mysqluserclone - Clone Existing User to Create New User

11.4. Parsers     [+/-]

11.4.1. mysql.utilities.parser — Parse MySQL Log Files

A. Third Party Licenses     [+/-]

A.1. .NET Flat TabControl License

A.2. Bitstream Vera License

A.3. Boost Library License

A.4. Cairo License

A.5. CTemplate (Google Template System) License

A.6. cURL (libcurl) License

A.7. DockPanel Suite License

A.8. Dojo Toolkit v1.7.0b1 License

A.9. GLib License (for MySQL Workbench)

A.10. Glitz License

A.11. GNU Lesser General Public License Version 2.1, February 1999

A.12. HtmlRenderer (System.Drawing.Html)

A.13. Libiconv License

A.14. Libintl License

A.15. Libxml2 License

A.16. Libzip License

A.17. Lua (liblua) License

A.18. Paramiko License

A.19. PCRE License

A.20. Pixman License

A.21. PyCrypto License

A.22. Python License

A.23. Scintilla License

A.24. ScintillaNET License

A.25. TinyXML License

A.26. TreeViewAdv for .NET License

A.27. VSQLite++ License

B. MySQL Workbench FAQ

C. MySQL Workbench Change History     [+/-]

C.1. Changes in Release 5.2     [+/-]

C.1.1. Changes in MySQL Workbench 5.2.38 (Not yet released)

C.1.2. Changes in MySQL Workbench 5.2.37 (26 December 2011)

C.1.3. Changes in MySQL Workbench 5.2.36 (3 December 2011)

C.1.4. Changes in MySQL Workbench 5.2.35 (23 September 2011)

C.1.5. Changes in MySQL Workbench 5.2.34 (26 May 2011)

C.1.6. Changes in MySQL Workbench 5.2.33b (21 March 2011)

C.1.7. Changes in MySQL Workbench 5.2.33 (11 March 2011)

C.1.8. Changes in MySQL Workbench 5.2.32 (05 March 2011)

C.1.9. Changes in MySQL Workbench 5.2.31a (13 December 2010)

C.1.10. Changes in MySQL Workbench 5.2.31 (08 December 2010)

C.1.11. Changes in MySQL Workbench 5.2.30 (20 November 2010)

C.1.12. Changes in MySQL Workbench 5.2.29 (12 October 2010)

C.1.13. Changes in MySQL Workbench 5.2.28 (19 September 2010)

C.1.14. Changes in MySQL Workbench 5.2.27 (01 September 2010)

C.1.15. Changes in MySQL Workbench 5.2.26 (06 August 2010)

C.1.16. Changes in MySQL Workbench 5.2.25 (30 June 2010, General Availability)

C.1.17. Changes in MySQL Workbench 5.2.24 (21 June 2010)

C.1.18. Changes in MySQL Workbench 5.2.23 (Internal release only)

C.1.19. Changes in MySQL Workbench 5.2.22 (02 June 2010)

C.1.20. Changes in MySQL Workbench 5.2.21 (12 May 2010, Release Candidate)

C.1.21. Changes in MySQL Workbench 5.2.20 (27 April 2010)

C.1.22. Changes in MySQL Workbench 5.2.19 (16 April 2010)

C.1.23. Changes in MySQL Workbench 5.2.18 (13 April 2010)

C.1.24. Changes in MySQL Workbench 5.2.17 (02 April 2010)

C.1.25. Changes in MySQL Workbench 5.2.16 (17 February 2010)

C.1.26. Changes in MySQL Workbench 5.2.15 (28 January 2010)

C.1.27. Changes in MySQL Workbench 5.2.14 (21 January 2010)

C.1.28. Changes in MySQL Workbench 5.2.13 (Not released)

C.1.29. Changes in MySQL Workbench 5.2.12 (Not released)

C.1.30. Changes in MySQL Workbench 5.2.11 (18 December 2009)

C.1.31. Changes in MySQL Workbench 5.2.10 (01 December 2009)

C.1.32. Changes in MySQL Workbench 5.2.9 (Internal release only)

C.1.33. Changes in MySQL Workbench 5.2.8 (18 November 2009, Beta)

C.1.34. Changes in MySQL Workbench 5.2.7 (Internal release only)

C.1.35. Changes in MySQL Workbench 5.2.6 (21 October 2009)

C.1.36. Changes in MySQL Workbench 5.2.5 (Internal Release Only)

C.1.37. Changes in MySQL Workbench 5.2.4 (07 October 2009)

C.1.38. Changes in MySQL Workbench 5.2.3 (15 September 2009)

C.1.39. Changes in MySQL Workbench 5.2.2 (27 July 2009)

C.1.40. Changes in MySQL Workbench 5.2.1 (22 May 2009)

C.1.41. Changes in MySQL Workbench 5.2.0 (30 April 2009, Alpha)

C.2. Changes in Release 5.1     [+/-]

C.2.1. Changes in MySQL Workbench 5.1.19 (06 September 2010)

C.2.2. Changes in MySQL Workbench 5.1.18 (03 September 2009, General Availability)

C.2.3. Changes in MySQL Workbench 5.1.17 (14 August 2009)

C.2.4. Changes in MySQL Workbench 5.1.16 (30 June 2009, General Availability)

C.2.5. Changes in MySQL Workbench 5.1.15 (26 June 2009)

C.2.6. Changes in MySQL Workbench 5.1.14 (19 June 2009)

C.2.7. Changes in MySQL Workbench 5.1.13 (12 June 2009)

C.2.8. Changes in MySQL Workbench 5.1.12 (27 April 2009)

C.2.9. Changes in MySQL Workbench 5.1.11 (Not yet released)

C.2.10. Changes in MySQL Workbench 5.1.10 (10 April 2009)

C.2.11. Changes in MySQL Workbench 5.1.9 (Not yet released, Beta)

C.2.12. Changes in MySQL Workbench 5.1.8 (Not yet released)

C.2.13. Changes in MySQL Workbench 5.1.7 (Not yet released)

C.2.14. Changes in MySQL Workbench 5.1.6 (Not yet released)

C.2.15. Changes in MySQL Workbench 5.1.4 (Not yet released)

C.3. Changes in Release 5.0     [+/-]

C.3.1. Changes in MySQL Workbench 5.0.30 (18 February 2009)

C.3.2. Changes in MySQL Workbench 5.0.29 (12 December 2008)

C.3.3. Changes in MySQL Workbench 5.0.28 (06 December 2008)

C.3.4. Changes in MySQL Workbench 5.0.27 (07 November 2008)

C.3.5. Changes in MySQL Workbench 5.0.26 (16 October 2008)

C.3.6. Changes in MySQL Workbench 5.0.25 (12 September 2008)

C.3.7. Changes in MySQL Workbench 5.0.24 (12 August 2008)

C.3.8. Changes in MySQL Workbench 5.0.23 (25 June 2008)

C.3.9. Changes in MySQL Workbench 5.0.22 (27 May 2008)

C.3.10. Changes in MySQL Workbench 5.0.21 (27 April 2008)

C.3.11. Changes in MySQL Workbench 5.0.20 (26 April 2008)

C.3.12. Changes in MySQL Workbench 5.0.19 (15 April 2008)

C.3.13. Changes in MySQL Workbench 5.0.18rc (not released)

C.3.14. Changes in MySQL Workbench 5.0.17rc (07 April 2008)

C.3.15. Changes in MySQL Workbench 5.0.16rc (26 March 2008)

C.3.16. Changes in MySQL Workbench 5.0.15rc (17 March 2008)

C.3.17. Changes in MySQL Workbench 5.0.14abeta (28 February 2008)

C.3.18. Changes in MySQL Workbench 5.0.14beta (25 February 2008)