oozie 创建oozie.sql文件时遇到 Could not connect to the database: java.lang.ClassNotFoundException: com.mysq

在创建oozie.sql文件时 bin/ooziedb.sh create -sqlfile oozie.sql -run 遇到如下报错：

Validate DB Connection

Error: Could not connect to the database: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Stack trace for the error was (for debug purposes):
--------------------------------------
java.lang.Exception: Could not connect to the database: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
        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.lang.ClassNotFoundException: com.mysql.jdbc.Driver
        at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:264)
        at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:892)
        at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:899)
        ... 3 more
--------------------------------------

应该是数据库连接不上的问题

1.检查了oozie-site.xml 的相关配置，发现没有问题

2.在/usr/my.cnf [mysqld]标签下添加一句：skip-grant-tables 还是无果

3.更换了驱动包 mysql-connector-java-5.1.27-bin.jar 

在oozie根目录的libext 重新用二进制的上传方式上传 发现解决了问题