Skip to main content
University of Florida

MySQL

There are several ways to manage your database.

  1. Login to glint-prod06.osg.ufl.edu via SSH and run the mysql client (this should also work from other computers where the mysql command line client is installed). The client computer must have an IP address with a reverse mapping to a ufl.edu address in order to connect. From off-campus (and some parts of campus) the UF VPN Client can be used to meet this requirement. Note: When using SSL from the mysql client, specify cipher type with the --ssl-cipher switch.

    For TEST databases:

    mysql --host ict-test-hostingNN.mysql.osg.ufl.edu --port 33NN --password --user <username> --database <databasename>
    For PROD databases: 
    mysql --host ict-prod-hostingNN.mysql.osg.ufl.edu --port 33NN --password --user <username> --database <databasename>
    NOTE: you will need to look at your mysql_credentials file to find the specific numbers which replace NN in the hostname and port number examples, above.
  2. Install a desktop application (such as the MySQL GUI tools) to manage your database. The client computer must have an IP address with a reverse mapping to a ufl.edu address in order to connect. From off-campus (and some parts of campus) the UF VPN Client can be used to meet this requirement.
  3. Install phpMyAdmin into one of your web hosting accounts. phpMyAdmin can run as a subdir under an existing site (e.g. mysite.ufl.edu/phpMyAdmin/ which would live in a directory similar to /h/cnswww-user/mysite.ufl.edu/htdocs/phpMyAdmin/). In the UFIT apache web hosting environment, you will likely need to adjust the PHP save session path for this to work.