Links

CS 451/551

MySQL links:
- If you are a student from another department, you will need to create an account on the department machine ix. To do this, run the newuser script from the system's Accounts page. When you are asked the account type, choose "Sponsored Account", and use the instructor's name as the sponsor. The "grad" and "undergrad" choices are for CIS students, which will work but will get you on email lists you don't want and irritate the front office staff that manage those lists.
- ☆ Installing MySQL on ix. After the installation:
  - start MySQL through mysqlctl start
  - stop it by mysqlctl stop
  - edit your .my.cnf file (note the "." in front of the file name)
  - you may need to edit that file from the command line, use ls -a to see the hidden "dot" files
  - comment out the line that says skip-innodb
  - ... and also the line that says default-storage-engine=myisam
  - restart MySQL
- After you create your instance on ix, you will need to add yourself as a new user from any host if you want to use it from outside the department. To do so,
  - Run MySQL from the command line, via mysql -p (or mysql -h ix -p)
  - CREATE USER 'cwilson'@'%' IDENTIFIED BY 'password';
  - GRANT ALL PRIVILEGES ON *.* TO 'cwilson'@'%' WITH GRANT OPTION;
  - ... or you can perform these two steps using MySQLWorkbench using the "Users and Privileges" tab, but you will have to be coming through the @cs.uoregon.edu domain (such as by connecting your laptop to an ethernet wire in Deschutes - wireless won't work since it goes through @uoregon.edu).
- ☆ If you don't want to install MySQL, you can use the instructor's instance. (This will be much easier if you are using a front-end, such as MySQLWorkbench.) Just point to server host ix.cs.uoregon.edu on port 3128 as user 'guest' with password 'guest'.
- ☆ MySQL Workbench. You should certainly put this on your personal machine, even if you use a MySQL instance running on a remote machine.
- You may also want to consider DBVisualizer as an alternate front-end, in place of MySQL Workbench.
- ☆ MySQL documentation.
PHP links:
- ☆ Documentation for the PHP mysqli extension.