Page Comparison

...

1. To check: Run mysql --help on the command line
2. 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/
3. 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"
4. 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
   1. 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 = 1

   2. OPTIONAL 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