MySQL

Home \| Table of Contents	MySQL	CloverETL 4.7.0
Prev	Examples of DB Connection Configuration	Next

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.

Create database clover_db, set charset and collate.

CREATE SCHEMA clover_db CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Use clover_db as the current database.
```
USE clover_db;
```

Create a new user with password and host.

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

Add all privileges to user 'clover' in DB clover_db.
```
GRANT ALL ON clover_db.* TO 'clover'@'%';
```
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