hadoop中 hive schema初始化数据库权限失败的解决办法

hadoop hive schema初始化数据库权限失败的解决办法

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Metastore connection URL: jdbc:mysql://172.30.16.80:3306/hive3?
Metastore Connection Driver : com.mysql.jdbc.Driver
Metastore connection User: test
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
Underlying cause: java.sql.SQLException : Access denied for user ‘test’@‘172.30.16.100’ (using password: YES)
SQL Error code: 1045

解决办法：
1. use mysql;
2. update user set password=password(“123”) where user=“root”;
3. flush privileges;
4. create user ‘test’@’%’ identified by ‘123’; //创建test用户，密码123，%表示所有主机都可连接
5.出现下图即可连接，还是使用root用户即可