MySQL Installation

connectDaily requires version 5.0 or higher of MySQL.

1. Download the MySQL JDBC Connector from the MySQL.com/Downloads/Connector web site. Copy the MySQL Connector/J JDBC Driver files to your application server's path, or the cdaily-5.0.0/WEB-INF/lib directory.
2. Create the database and user:
   
   user:~>mysql --user=root
mysql>create database calendar character set utf8;
mysql>grant all privileges on calendar.* to 'calendar'@'localhost' identified by 'calendar';
mysql>GRANT SUPER ON *.* TO 'calendar'@'localhost' IDENTIFIED BY 'calendar';
mysql>exit
3. Change to the cdaily-5.0.0/WEB-INF/sql/MYSQL directory. Create the database schema:
   
   user:~>mysql --user=calendar -p calendar
Enter Password:
mysql>\. calschema.sql
mysql>exit
4. user:~>mysql --user=root
mysql>REVOKE SUPER ON *.* FROM 'calendar'@'localhost';
mysql>exit
   
5. Configure the JDBC entries in the cdaily-5.0.0/WEB-INF/configuration.properties file
   
   DBObjectClass=com.MHSoftware.db.support.MySQLDB
JDBCConnectString=jdbc\:mysql\://localhost\:3306/calendar
JDBCDriver=com.mysql.jdbc.Driver
JDBCPassword=calendar
JDBCUserID=calendar