Graduate Windows Lab

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

We are now running MySQL Server in the Transaction Lab. This is installed on SBCSTLDB using the port 3306. The MySQL Query Browser client is installed on every machine.

To access MySQL in the Transaction Lab
Every student will receive a database userid exactly the same as their translab Windows/Network userids. The initial password of the database will be each student's 9-DIGIT STONY BROOK ID. Every account which is handed out has an empty database, the database/schema name and the database userid being the same unless specified otherwise.

You can access your database as follows:

• Start the MySQL Query Browser from the Programs Menu on your machine
• Specify the server as 'sbcstldb.translab.cs.sunysb.edu'
• Specify the port number as '3306'
• Specify the Username as your translab ID (unless otherwise specified)
• Specify your password as your SBID (unless otherwise specified)
• Specify your Default Schema as your Username.
• Click on OK.

For any concerns, questions or issues please contact us.