Accessing the database using MYSQL Workbench

Installation of MySQL Workbench should be relatively straightforward. To download it, go to the Workbench site. You'll need to install the packages under the heading "MySQL Workbench Prerequisites". Then, scroll to the bottom of the page, select your platform from the dropdown, and choose a distribution (most Windows platforms these days are 64-bit, FYI).

For more detailed Workbench installation instructions, go to the installation page on the website and select the options for your platform.

Once Workbench is installed, start it and select the button to create new connection (The plus sign next to the MySQL Connections text on the opening view of the application). A pop-up should then allow you to enter information to open a new connection. The connection name is up to you (I use "WWO" for Worldwater).

• Hostname: worldwater.byu.edu
• Port: 3306
• Username: WWO_Admin
• Password: You'll need to request it personally from Jiri Kadlec or Jon Belyeu (I can't post it on a public page).
• Default Schema: May be left blank

Hit the "Test Connection" button to verify that your connection works. You must be on BYU's wired internet to connect to the database. The database will not allow access from unsecured domains and even BYU wireless is not sufficient trusted. If the connection fails and you are connected to the wired domain, double check the connection information to make sure there are no misspellings.

When the connection is made successfully, a pop-up with the header "Successfully made the MySQL connection" will appear. Hit "OK" on that pop-up and the one you entered connection information into. Select the new connection box that should have appeared under the "MySQL Connections" text to open the connection if it does not open automatically. That box will allow you to reopen a saved connection as well.

In an open Workbench connection, there will be a list of schemas, or distinct databases, listed on the left. Find rush_valley in the list and navigate by clicking the drop-down arrows or enter SQL queries into the SQL editor that fills most of the window.