...
Users upgrading from MySQL 5.0 to MySQL 5.1 on a Mac have reported name comparison problems on startup (for more info see http://collab.sakaiproject.org/pipermail/sakai-dev/2010-June/008066.html. This issue is solved by specifying the following property in a local my.cnf configuration file:
| No Format |
|---|
lower_case_table_names=1
|
You will not need to create Sakai database objects (tables, indices, etc) when setting up your database. Sakai generates its own database schema automatically during the Tomcat setup process via the autoDDL setting in sakai.properties.
...
Before installing MySQL, confirm whether or not it is already installed on your system by checking the version from the command line:
| No Format |
|---|
mysql --version
mysql Ver 14.14 Distrib 5.1.52, for apple-darwin10.3.0 (i386) using readline 5.1
|
If MySQL is not installed download MySQL 5.01/5.1 5 binaries or source from http://dev.mysql.com/downloads/. Linux users should install MySQL using a package or binaries if possible. Choose the standard configuration. Windows users should consider installing MySQL as a service. Remember to include MySQL's /bin directory in your PATH statement.
MySQL 5.15: http://dev.mysql.com/downloadsdownlads/mysql/5.15.html
MySQL 5.01: http://dev.mysql.com/downloads/mysql/5.01.html
Assign a password for the root account:
| No Format |
|---|
mysql -u root -pmysqlpassword
|