失败了 安装cdhsh  scm_prepare_database.sh mysql -h192.168.1.11 -uroot -p123456 --scm-host 192.168.1.11  scmdbn scmdbu scmdbp

flink58 发布于 01/23 16:58
阅读 28
收藏 0

sh  scm_prepare_database.sh mysql -h192.168.1.11 -uroot -p123456 --scm-host 192.168.1.11  scmdbn scmdbu scmdbp
JAVA_HOME=/usr/java/latest/
Verifying that we can write to /data/cloudera-manager/cm-5.11.2/etc/cloudera-scm-server
[                          main] DbProvisioner                  ERROR Exception when creating/dropping database with user 'root' and jdbc url 'jdbc:mysql://192.168.1.11/?useUnicode=true&characterEncoding=UTF-8'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'%' to database 'scmdbn'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.8.0_191]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[:1.8.0_191]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.8.0_191]
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[:1.8.0_191]
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.Util.getInstance(Util.java:408)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2440)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)[mysql-connector-java.jar:5.1.46]
    at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:286)[db-common-5.11.2.jar:]
    at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:95)[db-common-5.11.2.jar:]
    at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:110)[db-common-5.11.2.jar:]
[                          main] DbProvisioner                  ERROR Stack Trace:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'%' to database 'scmdbn'
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.8.0_191]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[:1.8.0_191]
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.8.0_191]
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[:1.8.0_191]
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.Util.getInstance(Util.java:408)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2440)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)[mysql-connector-java.jar:5.1.46]
    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)[mysql-connector-java.jar:5.1.46]
    at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:286)[db-common-5.11.2.jar:]
    at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:95)[db-common-5.11.2.jar:]
    at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:110)[db-common-5.11.2.jar:]
--> Error 1, giving up (use --force if you wish to ignore the error)
 

加载中
返回顶部
顶部