Setting up MySQL Workbench (How-to)

In this article, you'll find the step by step guide to setting up MySQL Workbench.

NOTE: On initial setup, before you setup MySQL Workbench, you must run PuTTY. PuTTY setup only needs to be done once. You can find documentation on this process in the article, Setting up PuTTY for use in MySQL Workbench.

1. Connect to the Zimpleman Desktop in Windows App

  1. Open Windows App. If Windows App is not installed on your computer, please reference the knowledge base articles for Azure Virtual Desktops.
  2. Click on the Devices tab.
  3. Launch the Zimpleman Desktop by clicking Connect.

Launching the Zimpleman Desktop in Remote Desktop

2. Setting up MySQL Workbench

1. Open MySQL Workbench

  1. Click on the Search button (magnifying glass) on the task bar.
  2. In the search box, type in mysql.
  3. Click on MySQL Workbench. MySQL Workbench will now open.

Searching for and launching MySQL Workbench

2. Connect to the MySQL Database Server

There are two methods to add a new MySQL Database Server connection.

Method 1:

  1. In the menu bar, click Database.
  2. Click Connect to Database.

Connect to Database menu in MySQL Workbench

Method 2:

  1. On the MySQL Workbench splash screen, click the + icon to create a new connection.


 

  1. Type a name for the connection. Use the course name since it will be used later when opening the connection.
  2. In the Connect to Database window, ensure that the Connection Method is set to Standard (TCP/IP).
  3. In the Hostname field, type in data.drake.edu
  4. In the Username field, type in your Drake ID number (students), or last name (professors).
  5. Under Password, click Store in Vault...

  1. Type in your Drake Password and click OK.
  2. Once all connection settings have been configured, click OK to connect to the MySQL database server.
  3. The welcome screen will appear with the new connection under MySQL Connections. Select your new connection.

A Connection warning will likely appear and can be disregarded. Click Continue Anyway.


You should now see a screen similar to this and will be ready to start accessing the database.


 

Print Article