Page Comparison

...

1. Download and install MySQL ver 4.1 or better
   • http://dev.mysql.com/downloads/mysql/4.1.html
2. If a firewall is installed, allow port 3306 access (MySQL uses port 3306 to connect).
3. Create sakai database (from within mysql) Replace 'sakaiuser' and 'sakaipassword' with your desired username/password

   No Format
   mysql> create database sakai default character set utf8; mysql> grant all on sakai.* to sakaiuser@'localhost' identified by 'sakaipassword'; mysql> grant all on sakai.* to sakaiuser@'127.0.0.1' identified by 'sakaipassword';

   • Add the MySQL /bin directory to the system variables path
     • Right Click My Computer, Properties, Advanced, Environment Variables
     • Select the System variable Path and add C:\Program Files\MySQL\MySQL Server 4.1\bin to the end. Separate entries with a semi-colon.
     • Log off of the computer and log back on to reset system and environment variables.
4. Import the default table information into the Sakai database (from the command line)
   • Navigate to the sakai-dev\reference\src\sql\legacy\mysql directory

     No Format
     mysql -user=u sakaiuser -p sakai < all.sql

5. Download and install the JDBC connector
   • http://dev.mysql.com/downloads/connector/j/3.0.html
   • download Download the zip file
   • in From the zip file, copy only the mysql-connector-java-3.0.16-ga-bin.jar (mysql-connector JAR) file to the tomcat/common/lib directory
6. Comment out the HSQLDB lines in sakai.properties file in usr\local\sakai
7. Uncomment the MySQL lines in sakai.properties in usr\local\sakai
8. Start (or Restart) Tomcat
   • Navigate to http://localhost:8080/portal
   • Default username/password is 'admin/admin'

...