CISE Help & Resources
MySQL
Contents
Registering for a MySQL Account
To sign up for a CISE MySQL account, you will need to register for one using the the MySQL Account Registration Page. The page can also be used to set a new password for an existing MySQL account if you have forgotten your password.
MySQL accounts are now autocreated. You should receive mail to your CISE address within a half an hour of registration. If you do not, send mail to and let us know.
You will need to supply the following information on the registration page:
- CISE Username
- Enter your CISE username
- CISE Password
- Enter your CISE password
- MySQL Password
- Select a password for you postgres account and enter it here. The password
must meet the following criteria:
- The password must be 7 or 8 characters long (only the first 8 are used).
- The password must contain at least one letter (this stops things such as special dates, SSN, phone numbers, etc. from being used).
- At least 2 of the characters must be a special character or digit. At least 1 of these must be a special character (non-alphanumeric). The first character must not be a dash (-).
- The password must not contain your username.
- You should avoid starting with a single word and then doing common 1-character replacements such as replacing 'i' with 1 or 'a' with '\@'. Some of these will fail the good password check.
- Verify MySQL Password
- Enter your MySQL password again. It must match the first time.
- MySQL Database
- By default, when an account is created, it does not have access to any database. Either you must create a database, or you must be added to someone else's database. Likewise, you can add other people to your database.
Connecting to MySQL
All connections to the server mysql.cise.ufl.edu are host restricted. You must connect to mysql.cise.ufl.edu from a *.cise.ufl.edu domain. (for example: CISE lab machines, rain, sand, storm, and thunder). Wireless connections from within the CISE building do NOT have a *.cise.ufl.edu domain, and can not connect to MySQL.
If you need to connect to MySQL from a non *.cise.ufl.edu computer, you can ssh to one of the remotely accessable CISE machines (rain, sand, storm, and thunder) and connect from there.
Using MySQL on the Unix Command Line
Using MySQL on the command line is simple:
mysql -h mysql.cise.ufl.edu -u USERNAME -p DATABASE
Read the mysql man page for more info.
Generic MySQL Connection Parameters
If you're using an MySQL client and need to specify the paramters, use the following for MySQL accounts:
Server : mysql.cise.ufl.edu Port : 3306
Using JDBC with MySQL
The Java-MySQL Example shown here can be compiled with
% javac -classpath /usr/local/java/classes/mysql-connector-java.jar:. MySQLConnection.java
and run with
% java -classpath /usr/local/java/classes/mysql-connector-java.jar:. MySQLConnection
Or you can set your CLASSPATH in the shell and run either without the -classpath directive.
% setenv CLASSPATH /usr/local/java/classes/mysql-connector-java.jar:. % javac MySQLConnection.java % java MySQLConnection
PHP and MySQL DB Connections
PHP (/usr/local/bin/php) now supports MySQL. Please see the manual here. MySQL support is discussed here
A quick PHP exmple using mysql is available here.
Using Perl/DBI with MySQL
To use MySQL in perl, use the DBD::mysql module.
A short Perl example using DBI is here.