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 Citrix Workspace

  1. Open Citrix Workspace.
  2. At the top of the Citrix Workspace screen, ensure that Desktops is selected.
  3. Click on the Zimpleman Desktop.

Launching the Zimpleman Desktop in Citrix Workspace.

2. Setting up MySQL Workbench

1. Open MySQL Workbench

  1. Click on the Search button (magnifying glass) at the bottom left corner of the Citrix Workspace session.
  2. In the search box, type in mysql.
  3. Double click on the program MySQL Workbench.

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

Connect to Database menu in MySQL Workbench

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
Wed 9/13/23 8:26 AM