New MySQL Connection in Workbench

Overview

In this post, we will learn the steps to create a new MySQL connection in MySQL Workbench. Workbench is a graphical tool to interact with and manage MySQL server instances.

Environment

The following environment is used in this example:

  • Windows 11 Operating System
  • MySQL Workbench8.x

Launch Workbench

There are multiple ways to launch the tool. ( Launch MySQL Workbench)

The easiest method is to search for the name in the Search bar. Click on the search icon in the Taskbar. Type Workbench in the search bar.

Click on the MySQL Workbench search result to launch the tool.

 

MySQL Workbench Windows 11

New MySQL Connection

To create a new MySQL connection click on the + button on the Workbench welcome screen. Enter the following MySQL connection details:

  • Connection name
  • Connection method
  • Hostname
  • Port
  • Username
  • Password

The connection methods can be of many types. Choose from the drop-down that is an applicable connection method.

  • Standard TCP/IP
  • Standard TCP/IP over SSH
  • Socket/Pipe
  • LDAP User/Password
  • Native Kerberos
  • LDAPSasl/Kerberos

 

MySQL Test Connection Workbench Win11

Click on the Test Connection button to test the database connection. The test should be successful in order to connect to the database instance.

That’s it. We have successfully set up a new MySQL connection on the MySQL Workbench tool.

—

MySQL Tutorials

MySQL Tutorials on this website:

https://www.testingdocs.com/mysql-tutorials-for-beginners/

For more information on MySQL Database:

https://www.mysql.com/

Related Posts