Setting up MySQL Workbench (How-to)

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.

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.

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.

Method 2:

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

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

3. Type in your Drake Password and click OK.
4. Once all connection settings have been configured, click OK to connect to the MySQL database server.
5. 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.