Here is how you access the database server that has been set up for the class:

For host name, username and password, refer to the email from the TA.
To log into the server, first log into any CSIL machine (either remotely or directly). Please note that you can only access the server from within the UCSB network. So if you are outside the campus network, make sure that you log into the campus network or log into CSIL remotely.

The command to log in is:

_
 mysql -h sol.cs.ucsb.edu -u cs174a_test -p
_

Enter the password when prompted. As sample execution trace is as follows:

_
[user@csil ~]$ mysql -h sol.cs.ucsb.edu -u cs174a_test -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 133 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| cs174a_test        |
| test               |
+--------------------+
3 rows in set (0.00 sec)

mysql>
_

Use the cs174a_test database for practicing different aspects as you like. To change databases, the command is
_
mysql> use cs174a_test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>
_