create database dbName CHARACTER SET utf8 COLLATE utf8_bin;
create user 'theUser'@'localhost' identified by 'thePassword';
grant all privileges on dbName.* to 'theUser'@'localhost';

db.url=jdbc:mysql://localhost/dbNAme?useConfigs=maxPerformance&characterEncoding=utf8&innodb_flush_log_at_trx_commit=0
db.driver=com.mysql.jdbc.Driver
db.username=theUser
db.password=thePassword

mysql.optional.tabledefs=CHARSET=utf8 COLLATE=utf8_bin
    db.url=jdbc:mysql://localhost/6showcase?useConfigs=maxPerformance&characterEncoding=utf8&useSSL=false
    db.driver=com.mysql.jdbc.Driver
    db.username=root
    db.password=root

ERROR [localhost-startStop-8] [DataSourceImpl] error connecting to DataSource having url jdbc:mysql://localhost/6showcase?useConfigs=maxPerformance&characterEncoding=utf8&useSSL=false: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long
Aug 08, 2018 11:34:11 AM org.apache.catalina.core.StandardContext listenerStart
SEVERE: Exception sending context initialized event to listener instance of class [de.hybris.platform.spring.HybrisContextLoaderListener]