Connecting to your database on webpages using MySQL Workbench

If you are running a mac or linux, you can connect to webpages without putty as follows:

· Start a terminal (command line) and type

· ssh yourUserName@webpages.sou.edu

(For example, I use the following to login: ssh nordquip@webpages.sou.edu)

· enter your normal SOU password when prompted by ssh

Get putty

putty is an application for running a secure shell on a remote machine.  On the computers in PCE, it can be accessed from the start menu.  On your home machine, you may need to download it unless you have some other way of getting a command line on a remote machine.  You can download putty from http://download.cnet.com/PuTTY/3000-7240_4-10808581.html.

Start putty and connect to webpages.sou.edu

Open

Putty gives you a command line on the target machine

Type your SOU login name and password at the prompts.

Determine MySQL password

The MySQL server has its own password for your databases on webpages.sou.edu.  To determine this password, we must look at the file named .my.cnf

At the prompt, type:

cat .my.cnf

Record MySQL password

Notice the password line in the screenshot above:

password=ICENVJDu8a

(your password will be different than the example given here)

Write down the password you see in your file, as you will need it in the next steps.

To close putty, type:

exit  

Create MySQL Workbench connection to webpages.sou.edu

You can download MySQL Workbench from https://dev.mysql.com/downloads/workbench/5.2.html.  I used the MSI installer for Windows.

Start MySQL Workbench

(Yours will likely not have the Local Instance MySQL under Open Connection to Start Querying.)

Click on ‘New Connection’ in the ‘SQL Development’ column

Connection Name == webpages.sou.edu

Hostname == webpages.sou.edu

Username == yourUserName

Click Store in Vault button:

Enter the password you recorded at the end of the putty section above.

Click

OK

Click Test Connection button:

OK

OK

Connect to webpages

Double click webpages.sou.edu connection.

Select database

Double click usr_yourUserName_0