Setting up MySQL Workbench (How-to)

In this article, you will 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 Remote Desktop

  1. Open Remote Desktop. If Remote Desktop is not installed on your computer, please reference the knowledge base articles for Azure Virtual Desktops.
  2. Under Zimpleman College of Business, double click on Zimpleman Desktop.

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

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

Connect to Database menu in MySQL Workbench

  1. In the Connect to Database window, ensure that the Connection Method is set to Standard (TCP/IP).
  2. In the Hostname field, type in data.drake.edu
  3. In the Username field, type in your Drake ID number (students), or last name (professors).
  4. Under Password, click Store in Vault...
  5. Type in your Drake Password, and then click OK.
  6. Once all connection settings have been configured, click OK to connect to the MySQL database server.

MySQL Workbench connection settings


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


 

Details

Article ID: 48112
Created
Thu 2/8/18 2:57 PM
Modified
Fri 1/26/24 1:56 PM