IT Connect

Connecting You to Information Technology at the UW

Need Help?

Contact Us

Resources

Accessibility Accounts and Passwords Administrative Systems Appropriate Use Computer Labs Connecting Consulting Email Emergency Phones Questions & Ordering Printing Research Resources for IT Support Staff Safe and Secure Computing Skill Development Software and Hardware Teaching and Learning Teamwork Tools TV and Video Web Publishing

UW-IT

UW-IT Service Catalog UW-IT Billing

Using MySQL Workbench with MySQL on UW Shared Hosting

IT Connect > Web > Publishing > Using MySQL > Using MySQL Workbench

• On This Page
• Introduction
• Setting up MySQL Workbench

Introduction

This article demonstrates how to connect to a MySQL server using MySQL Workbench. It assumed that you already have familiarity with MySQL Workbench, and that you already have set up your MySQL server on a UW system. While UW Information Technology does not support the use of MySQL Desktop itself, limited troubleshooting is available for connection issues.

Note: You must set up your MySQL server before you can retrieve data from it.

Setting up MySQL Workbench

Logging into your MySQL server is a fairly straightforward process. These instructions will work on-campus as well as off-campus.

1. StepsActions

1. Download and install MySQL Workbench to your local computer.

2. Open MySQL Workbench. You should see a screen with three main columns, "SQL Development," "Data Modeling" and "Server Administration." Advanced users may want to try "Server Administration," but for most users, " SQL Development" should be sufficient. Click on "New Connection" below "SQL Development."

3. You will now configure the server connections. These settings will set up SSH Tunneling, so you can connect to your database securely no matter where you are located.

   Connection Name:	Name this connection something memorable. When in doubt, choose "UW MySQL Connection".
   Connection Method:	Select "Standard TCP/IP over SSH" from the drop-down menu.
   SSH Hostname:	If you are a student, enter in dante.u.washington.edu. Everyone else, enter homer.u.washington.edu
   SSH Username:	Your NetID. Even if you are working with another account, you will still want to connect using your own NetID.
   SSH Password:	Leave blank, and do not store in vault.
   SSH Key File	Unless you know what this is, leave blank.
   MySQL Hostname:	If the database server is on a student server, this will be vergil.u.washington.edu. For every other server, this is ovid.u.washington.edu. If one doesn't work, try the other.
   MySQL Server Port:	This is the port that your MySQL server is running on. If you forgot, it is in your ~/.my.cnf file.
   Username:	Unless you created another user, this will be root.
   Password:	Click on "Store in Vault" and then enter in your password for MySQL.
   Default Schema:	Leave Blank

4. Click on the "Advanced Tab" of the "Setup New Connection Window" and make sure that the following fields are checked: "Use Compression Protocol" and "Use SSL if available."

5. Click on "Test Connect." If all goes well, click on "OK." You're all set up! If it fails, go back and review your settings and make sure that your database is running.

Reviewed 8/27/12 | News Feed | News Archive | About IT Connect