Previous Topic

Next Topic

Book Contents

Book Index

MySQL Installation

Connect Daily 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-3.4.16/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>exit
  3. Change to the cdaily-3.4.16/WEB-INF/sql/MYSQL directory. Create the database schema:

    user:~>mysql --user=calendar -p calendar
    Enter Password:
    mysql>\. calschema.sql
    mysql>exit
  4. Configure the JDBC entries in the cdaily-3.4.16/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

See Also

SQL Database Setup

SQL Database Setup Overview

configuration.properties

Apache Derby Configuration

IBM DB2 Configuration

Microsoft SQL Server 2005-2012 Configuration

Oracle Configuration

PostgreSQL Configuration

Sybase Adaptive Server Anywhere Configuration

Converting from One Database to Another