安装oozie是报错问题

安装oozie时执行下面语句连接数据库时报错

先确保mysql里有数据库oozie

bin/oozie-setup.sh db create -run -sqlfile oozie.sql

报错

java.lang.Exception: Could not connect to the database: java.sql.SQLException: Access denied for user 'root'@'hadoop01' (using password: YES)
	at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:903)
	at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:183)
	at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:127)
	at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:78)
Caused by: java.sql.SQLException: Access denied for user 'root'@'hadoop01' (using password: YES)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1094)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:926)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1748)

解决，进入mysql的自带数据库中找到数据库mysql下的表user，修改表里的Host属性localhost为%，将出第一条的其他数据删除，然后在mysql的命令行执行flush pivileges;执行命令可以执行。

下个问题：执行bin/oozie-setup.sh prepare-war打war包报错

bin/oozie-setup.sh: line 235: unzip: command not found
Failed: unzipping Oozie input WAR

这是缺少upzip工具所以执行sudo yum -y install unzip

接下来运行又报错

bin/oozie-setup.sh: line 302: zip: command not found
Failed: unzipping Oozie input WAR

所以接着下载sudo yum -y install unzip

再运行就成功了！