Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

  • 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
  1. To check: Run mysql --help on the command line
  2. If not, download MySQL from:
  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 
      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
  • No labels