Using MySQL Workbench with MySQL on UW Shared Hosting
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.
Logging into your MySQL server is a fairly straightforward process. These instructions will work on-campus as well as off-campus.
Download and install MySQL Workbench to your local computer.
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."
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
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."
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.