Notes about using mysql: http://sensei.ad.umuc.edu/dwills/cmis320m/startup.txt Download the software: http://dev.mysql.com/downloads/mysql/5.0.html Windows Essentials Available locally: 16MB file \\kadenix\public\mysql-essential-5.0.21-win32.msi Install. (apparently have to be Admin account) Take all defaults except: skip Sign-up Turn on Include Bin Directory in Windows PATH Make root password: system Turn on the Anonymous user. OR, if can't install. get the 1.5MB client: \\kadenix\public\mysql.exe with the client you can connect to a MySQL server such as the one running at 192.168.1.10 #login from cmd: mysql -u root -p #OR mysql -u cmis320 -p -h 192.168.1.10 #what "databases" are available: SHOW databases; #use a database: USE world; #what tables are in current database: SHOW tables; #describe columns of a table: DESC city; SHOW CREATE TABLE city; SHOW TABLE STATUS; See: http://sensei.ad.umuc.edu/dwills/cmis320m/startup.txt http://sensei.ad.umuc.edu/dwills/cmis320m/select.txt http://sensei.ad.umuc.edu/dwills/cmis320m/datatypes.txt http://sensei.ad.umuc.edu/dwills/cmis320m/column_modifiers.txt Lab exercise: run the world queries of homeworks 2 and 3 in MySQL.