MySQL

Creating database

CloverDX Server setup

CloverDX Server supports MySQL 8.

Creating database

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

  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;
CloverDX Server setup

Example of a properties file configuration:

jdbc.driverClassName=com.mysql.cj.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.

arrow Continue with: Encrypted JNDI or Activation