MySQL Hosting Customer FAQ

To Manage your MySQL Database you have at least 3 options:

1. Login to glint.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 mysql.osg.ufl.edu --port 3307 --password --user <username> --database <databasename>

For PROD databases:

mysql --host mysql.osg.ufl.edu --port 3306 --password --user <username> --database <databasename>


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 CNS apache web hosting environment, you will likely need to adjust the PHP save session path for this to work (see http://open-systems.ufl.edu/content/apache-hosting-customer-faq#configphpsessions).