初始化报该错CDH 初始化数据库 报错ERROR Exception when creating/dropping database with user ‘root’ and jdbc url ‘jd

[2018-09-12 16:22:51,787]ERROR     0[main] - com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java) - Exception when creating/dropping database with user 'root' and jdbc url 'jdbc:mysql://10.100.200.40/?useUnicode=true&characterEncoding=UTF-8'
java.sql.SQLException: Access denied for user 'root'@'VM200-40' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)
    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4332)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1258)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2234)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2265)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2064)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:395)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
    at java.sql.DriverManager.getConnection(DriverManager.java:571)
    at java.sql.DriverManager.getConnection(DriverManager.java:215)
    at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:296)
    at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:104)
    at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:123)
[2018-09-12 16:22:51,792]ERROR     5[main] - com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java) - Stack Trace:
java.sql.SQLException: Access denied for user 'root'@'VM200-40' (using password: YES)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:870)
    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4332)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1258)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2234)
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2265)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2064)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:395)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
    at java.sql.DriverManager.getConnection(DriverManager.java:571)
    at java.sql.DriverManager.getConnection(DriverManager.java:215)
    at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:296)
    at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:104)
    at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:123)

在sql中运行

grant all privileges on *.* to 'root'@'192.168.222.110' 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'@'127.0.0.1.110' IDENTIFIED BY '123456' with grant option;

grant all privileges on *.* to 'root'@'%' IDENTIFIED BY '123456' with grant option;

grant all privileges on *.* to 'scm'@'192.168.222.110' IDENTIFIED BY 'scm' with grant option;

grant all privileges on *.* to 'scm'@'localhost' IDENTIFIED BY 'scm' with grant option;

grant all privileges on *.* to 'scm'@'127.0.0.1.110' IDENTIFIED BY 'scm' with grant option;

grant all privileges on *.* to 'scm'@'%' IDENTIFIED BY 'scm' with grant option;

flush privileges;

2、cloudera-scm-agent的日志路径（启动失败的时候）

/opt/module/cloudera-manager/cm-5.12.1/log/cloudera-scm-agent

查看该.out文件
cat cloudera-scm-agent.out
显示：

/usr/bin/env: python2.6: 没有那个文件或目录

运行下面红框中的代码，再次启动就可以了。 

cloudera-scm-agent启动失败 /usr/bin/env: python2.6: 没有那个文件或目录_还有重名？的博客-CSDN博客_cloudera-scm-agent 启动失败cloudera-scm-agent启动失败 查看.out文件显示/usr/bin/env: python2.6: 没有那个文件或目录。解决该问题后，cloudera-scm-agent启动成功。https://blog.csdn.net/qq_44743895/article/details/109625509Centos7下进行python2.6和yum完全卸载及重装_Somnolence.·.·.·.的博客-CSDN博客_rpm强制卸载Centos7下进行python2.6和yum完全卸载及重装1、删除现有Python#rpm -qa|grep python|xargs rpm -ev --allmatches --nodeps ##强制删除已安装程序及其关联#whereis python |xargs rm -frv ##删除所有残余文件 ##xargs，允许你对输出执行其他某些命令#whereis python ##...https://blog.csdn.net/qq_34180635/article/details/86078137