MySQL

CloverDX Server > Configuration > System Database Configuration > MySQL

CloverDX Server supports MySQL 5, up to version 5.6 included.

Creating Database

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

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;
```

CloverDX Server Setup

Example of a properties file configuration:

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

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 Activation