Skip to content

Introduction

MySQL is a relational database management system used to store, organize, and manage data. It allows users to create databases, store information in tables, and run queries to retrieve or modify data.

This documentation will walk you through how to use MySQL Workbench on Windows to do basic database work with its GUI (graphical interface). You'll learn to create a connection, create a schema (database), create a table, run queries, and edit data.

This is a beginner's guide to Workbench’s GUI, not a detailed guide to database theory or advanced MySQL.

Is This Guide for You?

This documentation is for people who want to learn how to use Workbench, and is specifically written for people running the Windows OS. Intended readers are:

  • Beginner developers who want to learn MySQL Workbench.
  • Students learning database management and core MySQL functionalities.
  • First-time users who have never worked with a database GUI before.

Prerequisite Knowledge

You should be familiar with basic computer tasks such as opening applications, switching between windows, using a mouse and keyboard, and navigating files and folders. You should also be comfortable typing text, copying and pasting, and following step-by-step instructions in a desktop application. You aren't required to have prior experience with MySQL.

Software Requirements

Note

This documentation was written and tested for MySQL Workbench 8.0. If you're using a different version, some menus, options, or screens might look different.

Typographical Conventions

Convention Explanation Examples
Commands & actions Bolded words for commands or actions you need to perform. Click, Enter, Type, Return, Open, Select
Code, SQL, and input values Monospace text for SQL commands, and input values. SELECT * FROM users;, username=root
Technical terms Technical terms are underlined when they are first introduced. You can hover over them, or tap the word on mobile to show their definition. schema, table, query

Notes, Warnings, and Results

You'll see branded callouts throughout the guide to highlight important information.

Common issue and fix

Steps marked Issue tell you a common issue, and how to fix it.

Warning

Steps marked Warning explain prerequisites or important conditions that may prevent you from completing the tutorial successfully.

Note

Note boxes provide extra explanation about what MySQL or Workbench is doing and why a step matters.

Success

Success boxes shows the expected result so you can confirm you’re on the right track.