How to configure ofbiz to mysql database.

1. Create  databases name ofbiz,ofbizolap and ofbiztenant in mysql.
2. Go to framework/entity/config/entityengine.xml and change this as below.

    <delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false">
 
        <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="localmysqlolap"/>
        <group-map group-name="org.ofbiz.tenant" datasource-name="localmysqltenant"/>
    
    </delegator>

    <delegator name="default-no-eca" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" entity-eca-enabled="false" distributed-cache-clear-enabled="false">
    
         <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="localmysqlolap"/>
        <group-map group-name="org.ofbiz.tenant" datasource-name="localmysqltenant"/>
     
    </delegator>


    <delegator name="test" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main">
      
        <group-map group-name="org.ofbiz" datasource-name="localmysql"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="localmysqlolap"/>
        <group-map group-name="org.ofbiz.tenant" datasource-name="localmysqltenant"/>
    
    </delegator>

and in  datasource localmysql,localmysqlolap,localmysqltenant change the bellow attributes:
jdbc-username="your mysql username"
jdbc-password="your mysql user password"
 
  jdbc-uri="jdbc:mysql://localhost/ofbiz?autoReconnect=true&amp;characterEncoding=UTF-8"(for localmysql datasource) 
 
  jdbc-uri="jdbc:mysql://localhost/ofbizolap?autoReconnect=true&amp;characterEncoding=UTF-8"(for localmysqlolap datasource)

  jdbc-uri="jdbc:mysql://localhost/ofbiztenant?autoReconnect=true&amp;characterEncoding=UTF-8"(for localmysqltenant datasource)

 Enjoy...