scm初始化的时候报com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'

报错日志

JAVA_HOME=/usr/java/jdk1.8.0_181-cloudera
Verifying that we can write to /etc/cloudera-scm-server
Wed Jan 18 22:11:22 EST 2023 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
[                          main] DbProvisioner                  ERROR Exception when creating/dropping database with user 'root' and jdbc url 'jdbc:mysql://feifan-test-cdh-001:3306/?useUnicode=true&characterEncoding=UTF-8'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'%' to database 'scm'
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.8.0_181]
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[:1.8.0_181]
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.8.0_181]
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[:1.8.0_181]
  at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.Util.getInstance(Util.java:386)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:829)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:729)[mysql-connector-java.jar:5.1.49]
  at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:299)[db-common-6.2.1.10e4e355f9397ec3d22db9e4464f47f8.jar:]
  at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:104)[db-common-6.2.1.10e4e355f9397ec3d22db9e4464f47f8.jar:]
  at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:123)[db-common-6.2.1.10e4e355f9397ec3d22db9e4464f47f8.jar:]
[                          main] DbProvisioner                  ERROR Stack Trace:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'%' to database 'scm'
  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)[:1.8.0_181]
  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)[:1.8.0_181]
  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)[:1.8.0_181]
  at java.lang.reflect.Constructor.newInstance(Constructor.java:423)[:1.8.0_181]
  at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.Util.getInstance(Util.java:386)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:829)[mysql-connector-java.jar:5.1.49]
  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:729)[mysql-connector-java.jar:5.1.49]
  at com.cloudera.enterprise.dbutil.DbProvisioner.executeSql(DbProvisioner.java:299)[db-common-6.2.1.10e4e355f9397ec3d22db9e4464f47f8.jar:]
  at com.cloudera.enterprise.dbutil.DbProvisioner.doMain(DbProvisioner.java:104)[db-common-6.2.1.10e4e355f9397ec3d22db9e4464f47f8.jar:]
  at com.cloudera.enterprise.dbutil.DbProvisioner.main(DbProvisioner.java:123)[db-common-6.2.1.10e4e355f9397ec3d22db9e4464f47f8.jar:]
--> Error 1, giving up (use --force if you wish to ignore the error)

原因是因为root用户没有grant的权限 

1.查看用户权限

SELECT host,user,Grant_priv,Super_priv FROM mysql.user;

查看root远程用户没有grant_priv的权限

2.更改用户权限

UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';

3.重新初始化