Install MySQL 5.1

MySQL - http://www.mysql.com
- You should download the MySQL Community Server
- NOTE: MySQL 5.5.x works but there are minor issues (mostly related to creating some profile 2 tables). If you already have 5.5 then you probably do not need to downgrade

To check: Run mysql --help on the command line
If not, download MySQL from:
- http://dev.mysql.com/downloads/mysql/5.1.html
  - Or if you want 5.5 or the current release: http://dev.mysql.com/downloads/mysql/
Custom install to /opt/mysql (options vary slightly based on operating system)
- Linux users should install MySQL using a package or binaries if possible
1. Choose standard configuration
2. Install as a windows service (Windows only)
3. Launch automatically (recommended)
  - If you choose not to do this, make sure that you startup MySQL each time before you try to run Sakai
4. Include the bin directory in Path
5. Don't use an anonymous account
6. Set your root password to "mysqlpwd1"
Update the mysql config file
- For linux/OSX this is going to be: /etc/my.cnf
- Windows: this file will be called my.ini and located in the dir you installed mysql into
- MySQL provides a number of preconfigured option files that can be used as a starting point for configuration. Look for my-small.cnf, my-medium.cnf, my-large.cnf and my-huge.cnf.
1. Add the following to the [mysqld] section
```
default-storage-engine = InnoDB
innodb_file_per_table
character-set-server=utf8
collation-server=utf8_general_ci
lower_case_table_names = 1
```
2. OPTIONAL for 5.5: Add this to enable logging
```
log_output=FILE
log=/tmp/mysql-query.log
slow-query-log=1
long_query_time=1
slow_query_log_file=/tmp/mysql-slow-query.log
expire_logs_days=5
```