CSG Zorrillo 3.0
Swinburne University of Technology
MySQL Database Information
The server runs mysql 5.1. Connections to the server must be made by a mysql client. You can not log into the mysql server using ssh/putty.
Connecting to the Server
The connection details are:
Host Name: mysql.ict.swin.edu.au Port: 3306 (This is the default) Connections permitted from: %.swin.edu.au
Note: Connections can not currently be made from eduroam (wireless).
Several other names have been used for the mysql server in the past. These are retained for legacy compatibility but the use of the new name is encouraged. The old names are:
mysql.it.swin.edu.au esrmysql.it.swin.edu.au neptune.it.swin.edu.au
For most users, your database username will be the same as your mercury username and your password will be your initial password (See Doc_mercury_student_password).
Your mysql password is not connected to your SIMS password or your mercury password. It is recommended that you do not use the same password for your mysql account.
Once you are connected to the server you can find out your database name(s) with the command
In most cases, a suitable set of default permissions is configured. If you require extra privileges, students should contact their subject convenor. Staff should contact the service desk (firstname.lastname@example.org).
The mysql command line client called mysql is the prefered method of connection. Users with a shell account on mercury.it.swin.edu.au can access the command line client by entering the command
The configuration file on mercury.it.swin.edu.au ensures that you are prompted for a password and connected to the correct server.
The command line client is also available on windows and can be downloaded for use on home computers.
If you are accessing a team database you must supply the username with the -u parameter like this
mysql -u hit1234_05
You will be prompted for the team password. You must obtain the team password from your convenor.
A web interface called phpMyAdmin is available at http://mercury.ict.swin.edu.au/mysql
There are plans to add mysql support to iSQLJunioR. Look for this soon.
Some versions of MySQL workbench will refuse to connect with the error
authentication protocol refused
To work around this error, edit the advanced connection settings and add
A local copy of the manual is available at http://mirror.it.swin.edu.au/mysql/doc/refman/5.1/en/index.html
PHP with mysql driver
Users are encouraged to use the PHP manual http://php.it.swin.edu.au/manual/en/book.mysql.php
PHP with PDO
The PHP Data Objects (PDO) extension defines a lightweight, consistent interface for accessing databases in PHP.
Changing your password
You can change your password by logging into mysql with the command line client and running these SQL statements:
SET SESSION old_passwords=0; SET PASSWORD = PASSWORD('YourNewPassword');
Do not use your SIMS, Novell or mercury etc. password. If you save your mysql password a .php script or similar there is a chance that it could be viewed in plain text by other users.
mysqldump is a handy tool which can be used to backup & restore mysql data. It has lots of options but normally the defaults work well. You may not have lock permissions on your database so you can skip the locking commands.
mysqldump --skip-lock-tables --skip-add-locks my_database > my_database.sql
This will write the database to a file called my_database.sql. This file can be transferred between systems if required.
mysql my_database < my_database.sql