OFBIZ搭建环境创建数据库的脚本模板

ofbiz 构建工具，换成了gradle，要重新搭建一套环境，那么首先，要创建数据库：

CREATE USER 'ofbiz'@'localhost' IDENTIFIED BY 'ofbiz'; 
CREATE USER 'ofbiz'@'%' IDENTIFIED BY 'ofbiz'; 

CREATE DATABASE ofbiz;
CREATE DATABASE ofbizolap;
CREATE DATABASE ofbiztenant;

GRANT ALL ON ofbiz.* TO 'ofbiz'@'%';
GRANT ALL ON ofbizolap.* TO 'ofbiz'@'%';
GRANT ALL ON ofbiztenant.* TO 'ofbiz'@'%';

GRANT ALL ON ofbiz.* TO 'ofbiz'@'localhost';
GRANT ALL ON ofbizolap.* TO 'ofbiz'@'localhost';
GRANT ALL ON ofbiztenant.* TO 'ofbiz'@'localhost';

flush privileges;

localmysqltenant
localmysqlolap
localmysql