Abstract
This is the MySQL Workbench Reference Manual. It documents the MySQL Workbench Community and MySQL Workbench Commercial releases for versions 8.0 through 8.0.38.
MySQL Workbench is developed and tested with MySQL Server 8.0. MySQL Workbench may connect to MySQL Server 8.4 and higher but some MySQL Workbench features may not function with those later server versions.
MySQL Workbench platform support evolves over time. For the latest platform support information, see https://www.mysql.com/support/supportedplatforms/workbench.html.
For notes detailing the changes in each release, see the MySQL Workbench Release Notes.
For legal information, including licensing information, see the Preface and Legal Notices.
If you have not yet installed the MySQL Workbench Community release, please download your free copy from the download site. The MySQL Workbench Community release is available for Microsoft Windows, macOS, and Linux.
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.
Document generated on: 2024-09-12 (revision: 79651)
Table of Contents
- Preface and Legal Notices
- 1 General Information
- 2 Installation
- 3 Configuration
- 4 Home Screen Tab
- 5 Connections in MySQL Workbench
- 5.1 Creating A New MySQL Connection (Simple)
- 5.2 Creating A New MySQL Connection (Tutorial)
- 5.3 Manage Server Connections
- 5.3.1 Standard TCP/IP Connection Method
- 5.3.2 Local Socket/Pipe Connection Method
- 5.3.3 Standard TCP/IP over SSH Connection Method
- 5.3.4 LDAP and Kerberos Connection Methods
- 5.3.5 SSL Wizard (Certificates)
- 5.3.6 Remote Management
- 5.3.7 System Profile
- 5.3.8 Configure Server Management Wizard
- 5.3.9 The Password Storage Vault
- 5.3.10 Updating Old Authentication Protocol Passwords
- 5.4 Client Connections
- 6 Administrative Tasks
- 7 Performance Tools
- 8 Database Development
- 9 Database Design and Modeling
- 10 Database Migration Wizard
- 10.1 General Installation Requirements
- 10.2 Migration Overview
- 10.3 Conceptual DBMS Equivalents
- 10.4 Microsoft Access Migration
- 10.5 Microsoft SQL Server Migration
- 10.6 PostgreSQL migration
- 10.7 MySQL Migration
- 10.8 Using the MySQL Workbench Migration Wizard
- 10.8.1 Connecting to the Databases
- 10.8.2 Schema Retrieval and Selection
- 10.8.3 Reverse Engineering
- 10.8.4 Object Selection
- 10.8.5 Migration
- 10.8.6 Manual Editing
- 10.8.7 Target Creation Options
- 10.8.8 Schema Creation
- 10.8.9 Create Target Results
- 10.8.10 Data Transfer and Migration Setup
- 10.8.11 Bulk Data Transfer
- 10.8.12 Migration Report
- 10.9 MySQL Workbench Migration Wizard FAQ
- A MySQL Workbench Frequently Asked Questions
- B Keyboard Shortcuts
- C Extending Workbench
- D How To Report Bugs or Problems
- E MySQL Enterprise Features
- F MySQL Utilities