安装完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

输入用户名主机名密码即可连接