解决Amabri Service数据库的连接性问题

本文主要是介绍解决Amabri Service数据库的连接性问题，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

解决ambari安装服务，数据库的连接性问题

场景

1. 安装hive service
2. 指定existing MySQL
3. MySQL位于node1
4. hive client位于node6
5. 服务器报连接性问题，指出'hive'@'%'无法连接数据库

solution

登录node1的MySQL

set global validate_password_policy=0;
set global validate_password_length=4;
CREATE USER 'hive'@'%' IDENTIFIED BY '********';
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'%';
CREATE USER 'hive'@'localhost' IDENTIFIED BY '********';
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'localhost';
CREATE USER 'hive'@'node6' IDENTIFIED BY '********'; 
GRANT ALL PRIVILEGES ON *.* TO 'hive'@'node6'; 
FLUSH PRIVILEGES;
$ mysql -uhive -phive
CREATE DATABASE hive

中间遇到的问题

mysql> CREATE USER 'hive'@'%' IDENTIFIED BY '********';
ERROR 1396 (HY000): Operation CREATE USER failed for 'hive'@'%'mysql> drop user 'hive'@'%'
mysql> CREATE USER 'hive'@'%' IDENTIFIED BY '********';

mysql> CREATE DATABASE hive;
ERROR 1007 (HY000): Can't create database 'hive'; database exists
mysql> drop database hive;
Query OK, 0 rows affected (0.05 sec)
mysql> CREATE DATABASE hive;

删了重建

这篇关于解决Amabri Service数据库的连接性问题的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---