New MySQL Connection in Workbench
Overview
In this post, we will learn steps to create a new MySQL connection in MySQL Workbench. Workbench is a graphical tool to interact and manage MySQL server instances.
Environment
- Windows 11 Operating System
- MySQL Workbench8.x
Launch Workbench
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.
New MySQL Connection
To create a new MySQL connection click on the + button in the Workbench welcome screen.
Enter the MySQL connection details:
- Connection name
- Connection method
- Hostname
- Port
- Username
- Password
Connection method can be many types. Choose form the drop down that is applicable.
- Standard TCP/IP
- Standard TCP/IP over SSH
- Socket/Pipe
- LDAP User/Password
- Native Kerberos
- LDAPSasl/Kerberos
Click on the Test Connection button to test the database connection. The test should be successful in order to connect to the database instance.
—
MySQL Tutorials
MySQL Tutorials on this website:
https://www.testingdocs.com/mysql-tutorials-for-beginners/
For more information on MySQL Database:
