具体错误为:org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
Underlying cause: java.sql.SQLException : null, message from server: “Host ‘DESKTOP-73BL0HG’ is not allowed to connect to this MySQL server”。意思是:根本原因:java.sql.SQLException:null,来自服务器的消息:“不允许主机’DESKTOP-73BL0HG’连接到此MySQL服务器”
原因是:
因为安装好mysql之后没有给相应的ip配置mysql权限。
解决方式:
进入mysql命令行界面:
use mysql;
select host,user,password from user;
如果配置的host不在user表中,使用如下命令给指定host配置权限:
grant all privileges on *.* to root@"指定ip" identified by "密码";
flush privileges;