解决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;

删了重建