oozie更改默认数据库为mysql

1、在mysql中设置访问权限

CREATE database oozie DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;  
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION; 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.27.226.73' IDENTIFIED BY '123456' WITH GRANT OPTION; 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'hadoop06' IDENTIFIED BY '123456' WITH GRANT OPTION;  
flush privileges;

查看是否赋予正常权限：

use mysql;
SELECT User, Password, Host FROM user;

2、在cm中生成数据表