1，部署ranger报错

1）

SQLException : SQL state: 42000 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user 'root'@'hdp-slave1.prd.cyber-insight.com' to database 'mysql' ErrorCode: 1044

image.png

权限问题
解决：

grant all on root.* to 'root'@'hdp-slave1.prd.cyber-insight.com' identified by '123456';

2)

u

解决

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

GRANT ALL ON *.* TO 'root'@'hdp-slave1.prd.cyber-insight.com';

3)

image.png

解决

set global log_bin_trust_function_creators=1;
 alter database ranger character set latin1;