Supported Setup: on Andrew Linux machines (command line)

1. Download MySQL Community Server 5.5.8 Linux - Generic Compressed TAR Archive
2. Unpack it. For example to: /afs/andrew.cmu.edu/usr2/ANDREWID/mysql

   tar -xvf mysql-5.5.15-linux2.6-x86_64.tar.gz mv mysql-5.5.15-linux2.6-x86_64 mysql setenv MYSQLBASE /afs/andrew.cmu.edu/usr2/ANDREWID/mysql

3. Go to the $MYSQLBASE directory and install SQL:
   

   scripts/mysql_install_db --datadir=$MYSQLBASE/data --user=ANDREWID

4. Make a directory for the socket used by the client/server dialogue - this should not be on afs space:

   mkdir /tmp/ANDREWID

5. Start the mysql server:

   bin/mysqld --basedir=$MYSQLBASE --datadir=$MYSQLBASE/data --log-error=$MYSQLBASE/data/mysql.err --pid-file=$MYSQLBASE/mysql.pid --socket=/tmp/ANDREWID/mysql.sock --port=3308 --user=ANDREWID

   Alternative to start mysql server (if you get an error when connecting with the client):

   bin/mysqld --basedir=$MYSQLBASE --datadir=$MYSQLBASE/data --log-error=$MYSQLBASE/data/mysql.err --pid-file=$MYSQLBASE/mysql.pid --socket=/tmp/ANDREWID/mysql.sock --port=3308 --user=ANDREWID --skip-innodb --default-storage-engine=myisam

6. Connect to the server:

   bin/mysql --socket=/tmp/ANDREWID/mysql.sock -u root

7. Once connected to the sql server, a prompt should appear. Use the following commands to create a new schema - before executing the commands indicated in the homework:

   > create database dbtest > use dbtest

8. To shut down the server:

   bin/mysqladmin -u root --socket=/tmp/ANDREWID/mysql.sock shutdown

OPTIONAL, unsupported setup: on your machine (with GUI)

• Download and install MySQL community server
  • Follow the installation instructions
• Download and install MySQL GUI tools
  • Follow the installation instructions in the manual
• During the installation you might be prompted to set a root password. If so, remember it, as you will need it to administer your server later on. If not, the root user will not have a password so leave the textbox blank when connecting.
• After installation is complete, check that the service is started (you might need to reboot your system)
  • on Windows: go to Control Panel > Local Services, look for MySQL and make sure its status is marked as Started
  • on Unix/MacOSx: use the "ps aux | grep MySQL" command
• Run MySQL Administrator, explore the GUI and make sure you know how to do the following:
  • change the TCP port on which the service is running (under Startup Variables)
  • stop/start the service
  • add a new user (under User Administration)
  • access the schemas - i.e. collections of tables - (under Catalogs)
• Create a new schema - call it, say, test-826
• Optional: make a dedicated user for the schema. This is sometimes done when a service/application requires generic access to the database irrespective of the user - web applications, for instance.
  • create a new user (test-826-user, for instance)
  • start MySQL query browser as root
    • server: localhost
    • user: root
    • port: 3306 (unless you changed it)
    • password: whatever you set it to during installation
    • default schema: mysql
    • give user test-826-user access privileges on schema test-826
      • go to 'User Administration'
      • click test-826-user
      • select the 'Schema Privileges' tab
      • select the test-826 schema
      • move privileges from the Available to the Assigned list
• To perform the tasks in Homework 0, run MySQL query browser and connect to the server on localhost either as root or test-826-user, with test-826 as you default schema

OPTIONAL, unsupported, fall-back set up: sqlite3

• Download the 'shell' version, for your OS - eg., for linux: http://www.sqlite.org/sqlite-shell-linux-x86-3070701.zip
  
• After you unzip it, at the shell prompt, type:
  

  sqlite3 hw0.db

• To import a 'csv' file, use the sqlite3 command .import (Notice that it starts with a 'dot').
• Try .help (again, it starts with a 'dot')