University of Florida :: Department of Computer and Information Science and Engineering (CISE)

CISE Help & Resources

MySQL

Registering for a MySQL Account

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 consult@cise.ufl.edu and let us know.

If you need to reset your MySQL password, create a new database, or change access permissions you can do so via the MySQL Administration.

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, sand.cise.ufl.edu, storm.cise.ufl.edu, and thunder.cise.ufl.edu). 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 (sand.cise.ufl.edu, storm.cise.ufl.edu, or thunder.cise.ufl.edu) 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.

Download this php.ini file in the directory you are using.

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.

Feedback