Home | Table of Contents | MySQL | CloverETL 4.6.1
--- | --- | ---
Prev | Examples of DB Connection Configuration | Next

## MySQL

CloverETL Server supports MySQL 5, up to version 5.5 included.

### Creating database

The following steps will create database `clover_db` and user `clover` with password `clover`.

1. Create database `clover_db`, set charset and collate.

       CREATE SCHEMA clover_db CHARACTER SET utf8 COLLATE utf8_unicode_ci;

2. Use clover_db as the current database.

       USE clover_db;

3. Create a new user with password and host.

       CREATE USER 'clover'@'%' IDENTIFIED BY 'clover';

4. Add all privileges to user 'clover' in DB clover_db.

       GRANT ALL ON clover_db.* TO 'clover'@'%';

5. Reload privileges.

       FLUSH privileges;

### CloverETL setup

If you use a properties file for configuration, specify these parameters: `jdbc.driverClassName, jdbc.url, jdbc.username, jdbc.password, jdbc.dialect.` For example:

    jdbc.driverClassName=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://127.0.0.1:3306/clover?useUnicode=true&characterEncoding=utf8
    jdbc.username=root
    jdbc.password=
    jdbc.dialect=org.hibernate.dialect.MySQLDialect

Please don't forget to add a JDBC 4 compliant driver on the classpath. A JDBC Driver which doesn't meet JDBC 4 won't work properly.

| Note
Continue with: Encrypted JNDI or CloverETL Server Activation

Prev | Up | Next
Embedded Apache Derby | Home | Table of Contents | DB2