resource_management.core.exceptions.Fail: Check db_connection_check was unsuccessful. Exit code: 1. Message: The MySQL JDBC driver has not been set.

在ambari中安装hive的时候报错：resource_management.core.exceptions.Fail: Check db_connection_check was unsuccessful. Exit code: 1. Message: The MySQL JDBC driver has not been set. Please ensure that you have executed 'ambari-server setup --jdbc-db=mysql --jdbc-driver=/path/to/jdbc

首先确保ambari客户端安装的节点安装了jdbc驱动

如果没有安装使用yum进行安装，如果没有网的话就自行下载 mysql-connector-java.jar

传到/usr/share/java目录下

然后执行命令：

ambari-server setup --jdbc-db=mysql --jdbc-driver=/usr/share/java/mysql-connector-java.jar

然后再测试连接，应该就没有问题了，如果还有问题，可以看看是不是mysql的远程连接没打开，使用别的远程连接工具试试。