mysql> grant all on *.* to 'temp'@'%' identified by 'temp' with grant option;
$ sudo /usr/share/cmf/schema/scm_prepare_database.sh mysql -h -utemp -ptemp --scm-host scm scm scm Looking for MySQL binary Looking for schema files in /usr/share/cmf/schema Verifying that we can write to /etc/cloudera-scm-server Creating SCM configuration file in /etc/cloudera-scm-server Executing: /usr/java/jdk1.6.0_31/bin/java -cp /usr/share/java/:/usr/share/cmf/schema/../lib/* /etc/cloudera-scm-server/ . [ main] DbCommandExecutor INFO Successfully connected to database. All done, your SCM database is configured correctly!
mysql> drop user 'temp'@'%'; Query OK, 0 rows affected (0.00 sec)
参考解决地址
/documentation/enterprise/latest/topics/cm_ig_installing_configuring_dbs.html#cmig_topic_5_2