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 web site. Copy the MySQL Connector/J JDBC Driver files to your application server's path, or the cdaily-4.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';
  3. Change to the cdaily-4.0.0/WEB-INF/sql/MYSQL directory. Create the database schema:

    user:~>mysql --user=calendar -p calendar
    Enter Password:
    mysql>\. calschema.sql
  4. user:~>mysql --user=root
    mysql>REVOKE SUPER ON *.* FROM 'calendar'@'localhost';
  5. Configure the JDBC entries in the cdaily-4.0.0/WEB-INF/ file

See Also

SQL Database Setup

SQL Database Setup Overview

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