Resources: COMPSCI 280 Semester 1, City Campus

The main download menu for MySQL is under:

http://www.mysql.com/downloads/

• Steps (for Windows):
  • Download the following
    • MySQL Community Server (installer includes the mysql client)
    • MySQL Workbench (GUI Tool) - this is optional
    • Connector/Net
  • Download the MSI installer versions of the Community Server for your platform.
  • Follow the setup instructions under http://dev.mysql.com/doc/refman/5.5/en/windows-install-wizard.html.
  • Log into the server by starting the mysql command line client from the Start menu, subfolder MySQL.
  • Issue the following SQL commands:
    
    UPDATE mysql.user SET Password = PASSWORD('thisisthenewpasswordyouhavechosen')
        WHERE User = 'root';
    FLUSH PRIVILEGES;
  • Install the Workbench and the Connector/Net

The reference manual for MySQL 5.0 (the version used on the university MySQL server) is here.

Science has a license for a range of Microsoft software. The software is available for free download for staff and students from this url:

http://msdn.cs.auckland.ac.nz/

• Note, you must be enrolled in the COMPSCI280 course to have access to the directory.
• Steps:
• Click the Log in button to log in.
• Select the software, you can choose from the following
  • Visual Studio 2008 Express Edition with SP1 748MB , OR
  • Visual Studio 2008 SP1 831MB , OR
  • Visual Studio 2008 Professional Edition (x86 and x64 WoW) - DVD 3.3GB
• Click the Go button
• Check the name of the program and click the Add to Cart button to continue.
• Click the I Agree button
• Click he Check Out button
• Fill in your surname, firstname and email address
• Click the Download link
• Click the Download button to start downloading

• The lecturer and tutors have office hours (see the People page)
• Attend tutorials (see the Tutorials page)
• Discuss with other students using the course Forum (log in the Forum)