Instructions for connecting to the MySQL database server using MySQL Workbench 5.x

 

Open MySQL Workbench (Start-> All Programs -> MySQL -> MySQL Workbench)

 

 

Create a New Connection: Under SQL Development side, click on New Connection. Fill out the information required:

                Connection name: cardhu

                Host: cardhu.academy.usna.edu

                Username: mXXXXXX, where XXXXXX is your alpha

                Default schema: mXXXXXX

Click on "Test Connection" button to ensure everything is OK. Provide the password provided by your instructor when requested. If you get the "permission denied" message, contact your instructor. Click OK to finish creating the connection.

 

 

Open Connection to Start Querying: Double click the "cardhu" connection and provide the password. Click "OK". The "SQL Editor" should open up.

 

 

 

Write and execute SQL:

You can write SQL queries in the top pane. To execute queries, see the "Query" menu.

 

Tips:

                End each query with ";"

                You can also open a script (text file with extension ".sql") with a list of SQL queries from File-> Open SQL Script.