MySQL

Install MySQL Client Connection Tool Workbench (Windows Version) (MySQL 8.0~)

Page creation date :

Operation confirmation environment

MySQL
  • MySQL 8.4
MySQL Workbench
  • 8.0
Windows
  • Windows Server 2022

Required environment

MySQL
  • MySQL 8.4
MySQL Workbench
  • 8.0
Windows
  • Windows 11
  • Windows 10
Windows Server
  • Windows Server 2022
  • Windows Server 2019
  • Windows Server 2016

precondition

  • The MySQL database must be installed on the PC or another PC where you want to put MySQL Workbench in.
  • If you have a MySQL database server on a PC other than the PC where you want to put MySQL Workbench, it must be configured to be connected from this PC.

About MySQL Workbench

Workbench is a GUI tool for working with databases that are officially supported by MySQL. The database status is displayed as a screen, so I think it is easier to understand information and operations than command-based. However, not all database operations are supported, and some may require the use of commands. The basic operation is almost entirely controllable in the GUI.

By the way, Workbench is a client tool for working with databases, so there is no need to install a MySQL server in the environment where Workbench is used. If you have a MySQL database on another server, Workbench will operate that database over the network.

Starting with MySQL 8.4, MySQL Workbench is not included in the database installer, so if you want to use Workbench on a PC with MySQL installed, you will need to install it separately.

download

In your web browser, go to the following pages:

Click Download MySQL Community Edition.

Click MySQL Workbench.

Select Micorsoft Windows and click the Download button below.

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

install

Run the downloaded file.

If you do not have administrator privileges, the following dialog will appear, select Yes.

Select "Yes" as it will appear again in another file.

Click Next.

If there are no changes to the installation path, click Next.

There are no detailed settings, so select "Complete".

Click the "Install" button.

Close with the "Finish" button.

Connect to the database server

Select MySQL -> MySQL Workbench 8.0 CE from the Start menu to run it.

Add a connection to the database. Click the plus button for MySQL Connections. By the way, if you start Workbench on a PC where the database is installed, the connection is created from the beginning.

Fill in the following fields: Depending on the environment, those not listed are set as default settings.

Parameter Name Description
Connection Name It can be named any time. Make it easy to understand where it connects.
Hostname Specify the destination host where the MySQL database is located. DNS names may not connect, so please enter your IP address in that case.
Port This is the port to use. If you haven't changed anything else, you should be able to connect with the default 3306.
Username Enter the name of the connectable user account that you are creating in the database.
Password Click the button to enter the password for the connected user.

Once you have entered it, click the "Test Connection" button in the bottom right corner to see if you can connect.

If you are able to connect successfully, you will see a dialog like the following:

Once you have confirmed the connection, you can click the OK button in the bottom right corner to create a connection.

After creating one, you can select the connection from the bottom of the home screen.

If you haven't saved your connection password, you'll be asked to enter your password.

If the following dialog is displayed when connecting, please understand the precautions before connecting.

Incompatible/non-standard server version or connection protocol detected (8.4.3).

You can establish a connection to this database, but some MySQL Workbench features may not work correctly because the database is not fully compatible with any supported versions of MySQL.

MySQL Workbench has been developed and tested for MySQL Server versions 5.6, 5.7, and 8.0. Note: It may not be compatible with version 8.4. For versions older than MySQL Server 5.6, use MySQL Workbench version 6.3.

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

Installing MySQL 8.4 for Windows
Settings to allow other PCs to connect to MySQL databases (Windows version)