MySQL Setup

Connecting to the Server

The Server listens on port 3306 (the default port) on mysql.it.usyd.edu.au. Connections to the server can currently only be made from inside the School of Information Technologies network.

Only the mysql command shell is in the default path on the School's Unix systems. If you wish to use other MySQL utilities, you should edit your .bash_profile (in your home directory) and add to the end:

PATH=/local/usr/mysql/bin:$PATH 
export PATH 

Save the new .bash_profile, log out and log back in again.

Your MySQL database password can be changed using the mysqladmin tool.

The correct syntax is:

mysqladmin -hmysql.it.usyd.edu.au -u<username> -p<oldpassword> password <newpassword> 

The absence of white-space between the -p and the password, and the -u and the username is essential! The command will not function correctly without it.

Also note that standard shell escaping is required if certain punctuation is to be used. If you don't know how to escape your password correctly, do not use the ampersand (&), exclamation mark (!), parenthesis of any kind, backslash (\) or single or double quotation marks (' and ") in the password.