JDOFatalDataStoreException: Unable to open a test connection to the given database. JDBC url = jdbc:

安装好hive和mysql之后，配置了hive的hive-site.xml
但是启动一直报错

没办法开始找错，不知道错哪里，只知道是mysql的原因
我的解决办法
1登录mysql
mysql -uroot -p密码
如果是新装的mysql的话，需要查看密码之后再进行登录 cat /root/.mysql_secret
OEXaQuS8IWkG19Xs
mysql -uroot -pOEXaQuS8IWkG19Xs
mysql>SET PASSWORD=PASSWORD(‘123456’);
2进入mysql
mysql>use mysql;
3查询
mysql>select user,password from user;

mysql> delete from user where 1=1;

4修改权限
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
5刷新
mysql> flush privileges;
6退出mysql之后登录hive

成功