MySQL

Install the MySQL client connection tool Workbench (for Windows)

Page update date :
Page creation date :

Operating environment

MySQL
  • MySQL 8.0
Windows
  • Windows 10

Prerequisites

MySQL
  • MySQL 8.0
Windows
  • Windows 11
  • Windows 10
Windows Server
  • Windows Server 2022
  • Windows Server 2019
  • Windows Server 2016
  • Windows Server 2012 R2

precondition

  • A MySQL database installed on a separate PC.
  • The MySQL database server must be configured so that you can connect to it from your PC.

About MySQL Workbench

Workbench is a GUI tool for working with databases that are officially supported by MySQL. Since the status of the database is displayed as a screen, I think that information and operations are easier to understand than the command base. However, not all database operations are supported, and some may require the use of commands. Most of the basic operations can be operated with the GUI.

By the way, Workbench is a client tool for working with databases, so you do not need to install a MySQL server in an environment that uses Workbench. If you have a MySQL database on another server, you will have Workbench working with that database over the network.

You can install Workbench with MySQL installation, so you do not need to install Workbench separately on the MySQL server.

download

In a web browser, access the following pages:

Click Download MySQL Community Edition.

Click MySQL Workbench.

Select "Microsoft Windows" and click "Go to Download Page".

Click the Download button. As for the difference between the top and bottom installers, the upper one installs while downloading the file at the time of installation. The following is the difference between downloading and installing all at once from the beginning, so in the end both will be the same.

You will be asked to log in, but you can download it from the link below without logging in.

install

Run the downloaded file.

Select Yes.

It will be displayed again in a different file, so select "Yes".

Workbench is a client tool, so select Client only.

This is the installation confirmation screen for the prerequisites. What you need on this screen varies depending on the environment of the OS you are running. If you do not need to add it, this screen will not be displayed, so please skip it.

This is the screen that appears when the Microsoft Visual C++ 2019 Redistributable is required. Follow the on-screen instructions for installation.

When the installation is complete, click the "Next" button.

If you are running the installer while downloading, you will need to download it. Click the Execute button. If you are a full installer, you will not see this screen.

When you're done, click the Next button.

Start the installation. Click the Execute button.

When the installation is complete, click the "Next" button.

Click the Next button.

Since there is no need to configure the MySQL router configuration, click the "Finish" button as it is.

Click the Next button.

Click the "Finish" button to complete the installation. When each check box is checked, Workbench and Shell are launched, respectively.

Connect to the database server

From the Start menu, select "MySQL -> MySQL Workbench 8.0 CE" and run it.

Add a connection to the database. Click the plus button for MySQL Connections.

Enter the following: It depends on the environment, but those that are not listed are set to the default settings.

Parameter name explanation
Connection Name You can name it whatever you want. Make it easy to understand where to connect it.
Hostname Specify the host to which the MySQL database is located. If it is a DNS name, it may not be connected, so please enter the IP address in that case.
Port The port to use. If you haven't changed anything, you should be able to connect with the default 3306.
Username Enter the name of the user account that you are creating in the database that you can connect to.
Password Click the button to enter the password for the connected user.

After entering, click the "Test Connection" button at the bottom right to see if you can connect.

If the connection is successful, the following dialog will be displayed.

Once you have confirmed the connection, you can create the connection by clicking the OK button in the lower right corner.

Once created, you can select a connection from the bottom of the home screen.

I was able to check the information of the connection destination.

Settings to allow other PCs to connect to MySQL databases (Windows version)
Backing Up and Restoring MySQL Databases (Windows Version)