MySQL Workbench User Guide
An user guide for frequently performed tasks on MySQL Workbench.
Introduction
Welcome! MySQL Workbench User Guide is a step-by-step instruction guide for frequently performed tasks on MySQL Workbench. The documentation for each task can be completed sequentially and takes readers through creating new schemas to writing and executing MySQL statements.
MySQL Workbench (or just Workbench) is an application software for database design using the popular relational database management system, MySQL. A powerful tool for software developers, Workbench provides a visual environment to create, execute, and optimize databases through its graphical user interface or with queries written in the SQL programming language.
Intended User Groups
The user documentation in MySQL Workbench User Guide is intended for the following users:
- New users who want to start learning MySQL
- Returning users who want to review MySQL’s commands
Software Requirements
- MySQL
- MySQL Workbench 8.0 CE
Prerequisites
- Have access to a working computer and the ability to perform basic computer-oriented tasks.
- Have the ability to navigate various interfaces using a set of given instructions.
- Already set up a MySQL connection. If not, please refer to our MySQL Workbench Setup Guide.
Why MySQL
- MySQL is one of the easiest and most secure ways to maintain and update a database.
- MySQL provides high-performance at a low cost. In fact, MySQL community edition is free!
- MySQL is flexible and usable across all major platforms including Windows, Mac, Linux, Ubuntu and more.
Procedures Overview
Typographical Conventions
📖: Additional information
> This icon notes where additional information, such as notes and shortcuts, is provided.
⚠️: Dangerous action
> This icon notes where a dangerous action could take place.