MySql Connection Information

For a tutorial on using MySQL, please refer to http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

Connecting to MySql using the QueryBrowser (recommended)

You will be given an MySql Username/Password to connect to the database. Every account which is handed out is typically has an empty schema. You will need to create database objects under your schema.

• Click on Start
• Go to Programs
• Click On MySql->MySql QueryBrowser

Login Window

• Leave Stored Connection empty
• Enter the Server Host as rdb.translab.cs.sunysb.edu
• You do not need to change the Port number.
• Enter the UserName and Password, given to you.
• Enter the Default Schema the same as your UserName.
• Click Ok.
• You can run queries on the database that you create in the MySQL browser
• For tutorials on using the query browser (left side of page), please refer to http://www.mysql.com/products/tools/query-browser/

Connecting to MySql using the Command Line client

• The command line client is very useful to run batch commands
• Open a Command Window (Start->Run->cmd)
• Change directory to c:\Program Files\MySQL\MySQL Server 5.0\bin
• Run the following command
  • mysql -h rdb.translab.cs.sunysb.edu -u <username> -p
• You will be prompted for your password
• For further instructions on using the command line client, please refer to http://dev.mysql.com/doc/refman/5.0/en/mysql.html