Use the up and down arrows to select a result. Press enter to go to the selected search result. Touch device users can use touch and swipe gestures.
Version CloverDX 6.7.0

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