Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  Database  >  How to Connect to a Database via MySQL Workbench?
Top Scroll

How to Connect to a Database via MySQL Workbench?

 2 min

MySQL Workbench is an open-source application to connect with the databases on server machines from any computer.

You can download MySQL Workbench at this link for free:

https://dev.mysql.com/downloads/workbench/

Note: Before installing the MySQL Workbench, the system requires you to install the Visual C++ Redistributable Package version 2015-2019. The installation will not proceed unless you do so.

To Connect with a Database via MySQL Workbench

1. Open the MySQL Workbench application.

2. Click on the ‘+’ icon beside the MySQL connections, as shown in the screenshot.

3. The Set up a New Connection dialogue box will open. Enter the necessary details in the respective fields. Here’s a description to help you understand how to fill them.

  • Connection Name: Enter the name for your connection here.
  • Connection Method: The method/protocol with which MySQL Workbench makes the connection. Leave it as the default: Standard (TCP/IP).
  • Hostname: The IP address of the host where the database is located.
  • Port: No need to change it from the default 3306.
  • Username: Enter the username for your control panel account or the created user for the database.
  • Password: Enter the password for your control panel account or the database user you created. Click on Store in Vault.

The Store Password For Connection window will open. Enter the password and click OK.

5. To check if the connection can be established, click the Test Connection button.

6. A success message shows up and displays the information related to the connection. Click on OK.

7. Click OK of the Set up a New Connection dialogue box to create the connection.

8. The newly created connection gets listed below the MySQL connections. Click on the connection.

The database is opened in the adjacent window displaying its tables.

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
30
MINS
59
SECS
Claim the discount before it’s too late. Use the coupon code:
STORYSAVER
Note: Copy the coupon code and apply it on checkout.