OpenKM 5.x with MySQL

DROP DATABASE IF EXISTS okm_repo; DROP DATABASE IF EXISTS okm_app;
CREATE DATABASE okm_repo DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
CREATE DATABASE okm_app DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_bin;
CREATE USER 'openkm'@'localhost' IDENTIFIED BY 'h3ll0$';
GRANT ALL ON okm_repo.* TO 'openkm'@'localhost' WITH GRANT OPTION;
GRANT ALL ON okm_app.* TO 'openkm'@'localhost' WITH GRANT OPTION;

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource> 
	<jndi-name>OpenKMDS</jndi-name> 
	<connection-url>jdbc:mysql://localhost:3306/okm_app?autoReconnect=true</connection-url> 
	<driver-class>com.mysql.jdbc.Driver</driver-class> 
	<user-name>openkm</user-name> 
	<password>h3ll0$</password> 
	<min-pool-size>5</min-pool-size> 
	<max-pool-size>20</max-pool-size> 
	<idle-timeout-minutes>28680</idle-timeout-minutes> 
	<exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name>
	<valid-connection-checker-class-name>com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name>
	<metadata> <type-mapping>mySQL</type-mapping></metadata> 
</local-tx-datasource>
</datasources>

<Workspace name="${wsp.name}">
....
<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
  <param name="driver" value="com.mysql.jdbc.Driver"/> 
  <param name="url" value="jdbc:mysql://localhost:3306/okm_repo?autoReconnect=true"/> <param name="schema" value="mysql"/>
  <param name="user" value="openkm"/>
  <param name="password" value="h3ll0$"/>
  <param name="schemaObjectPrefix" value="${wsp.name}_"/>
  <param name="externalBLOBs" value="false"/> 
</PersistenceManager>
....
</Workspace>
<Versioning rootPath="${rep.home}/version">
...
<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
  <param name="driver" value="com.mysql.jdbc.Driver"/>
  <param name="url" value="jdbc:mysql://localhost:3306/okm_repo? autoReconnect=true"/>
  <param name="schema" value="mysql"/> 
  <param name="user" value="openkm"/> 
  <param name="password" value="h3ll0$"/> 
  <param name="schemaObjectPrefix" value="version_"/> 
  <param name="externalBLOBs" value="false"/>
</PersistenceManager>
...