FAQs - MySQL

1. What is the initial password for my account?
Your MySQL account password is stored separately from your Linux password.  The default password is 'u' followed by the last seven digits of your student ID number.  It is not 'u$' and the last six digits.  CHANGE YOUR PASSWORD THE FIRST TIME YOU LOG IN!  You can do this by logging into mysql and typing: 
mysql> set password = password("yournewpassword");
2. How can I access it from a Linux machine?

Under linux you can do the following, for tcsh or csh:

mysql -h mysql -p

where "-h mysql" marks the hostname mysql.cs.uky.edu.  If you leave "-h mysql" out, you'll see an error message like:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

 but with "-h mysql", it should then ask for your password (see FAQ 1).  You should then tell mysql to use your database:

mysql> use mylogin;

where "mylogin" is the same as your uderid.  You can then create tables, etc.

 

3. How should I access it via my webserver program?

The www.cs.uky.edu webserver and the mysql.cs.uky.edu share a local network not on the UK campus network. This is a gigabit network and therefore should be faster than the campus connection. Your mysql host should be "mastelottoplan.backups.uky.edu", which will only work from the www.cs.uky.edu webserver.

 

4. What about backups?

The mysql server is available for learning and research purposes. No live data should exist only in the database. There are no data dumps of the database tables, so you should keep your own in case of a failure or of an accidental deletion/modification.