安装完MySQL后,使用mysql命令进去,然后执行以下命令
grant all privileges on hive_metadata.* to 'hive'@'%' identified by '123456';
grant all privileges on hive_metadata.* to 'hive'@'localhost' identified by '123456';
grant all privileges on hive_metadata.* to 'hive'@'wang201' identified by '123456';
flush privileges;//刷新权限
然后打开Navicat
输入用户名主机名密码即可连接