- 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/
- http://dev.mysql.com/downloads/mysql/5.1.html
- Custom install to /opt/mysql (options vary slightly based on operating system)
- Linux users should install MySQL using a package or binaries if possible
- Choose standard configuration
- Install as a windows service (Windows only)
- Launch automatically (recommended)
- If you choose not to do this, make sure that you startup MySQL each time before you try to run Sakai
- Include the bin directory in Path
- Don't use an anonymous account
- 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.
Add the following to the [mysqld] section
No Format default-storage-engine = InnoDB innodb_file_per_table character-set-server=utf8 collation-server=utf8_general_ci lower_case_table_names = 1OPTIONAL for 5.5: Add this to enable logging
No Format 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