基于Cloudera Manager Server的WebUI添加Hive服务实战案例

　　　　　　基于Cloudera Manager Server的WebUI添加Hive服务实战案例

　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　作者：尹正杰

一.MySQL授权hive用户的准备工作

[root@cdh101.yinzhengjie.org.cn ~]# mysql -uroot -pyinzhengjie
Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MariaDB connection id is 12
Server version: 5.5.64-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

MariaDB [(none)]> 
MariaDB [(none)]> CREATE DATABASE hive  CHARACTER SET = utf8;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> 
MariaDB [(none)]> GRANT ALL PRIVILEGES ON hive.* TO 'hive'@'172.200.2.%' IDENTIFIED BY 'yinzhengjie' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> 
MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> 
MariaDB [(none)]> SELECT user,host,password FROM mysql.user;
+------+-------------+-------------------------------------------+
| user | host        | password                                  |
+------+-------------+-------------------------------------------+
| root | localhost   | *BD0B1F48FDC55BD27555FC2F22FF29A68A25A1D7 |
| root | 127.0.0.1   | *BD0B1F48FDC55BD27555FC2F22FF29A68A25A1D7 |
| root | ::1         | *BD0B1F48FDC55BD27555FC2F22FF29A68A25A1D7 |
| hive | 172.200.2.% | *BD0B1F48FDC55BD27555FC2F22FF29A68A25A1D7 |
| cm   | 172.200.2.% | *BD0B1F48FDC55BD27555FC2F22FF29A68A25A1D7 |
+------+-------------+-------------------------------------------+
rows in set (0.00 sec)

MariaDB [(none)]> 
MariaDB [(none)]> SHOW GRANTS FOR 'hive'@'172.200.2.%';
+---------------------------------------------------------------------------------------------------------------+
| Grants for hive@172.200.2.%                                                                                   |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'hive'@'172.200.2.%' IDENTIFIED BY PASSWORD '*BD0B1F48FDC55BD27555FC2F22FF29A68A25A1D7' |
| GRANT ALL PRIVILEGES ON `hive`.* TO 'hive'@'172.200.2.%' WITH GRANT OPTION                                    |
+---------------------------------------------------------------------------------------------------------------+
rows in set (0.00 sec)

MariaDB [(none)]> 
MariaDB [(none)]> QUIT
Bye
[root@cdh101.yinzhengjie.org.cn ~]# 
[root@cdh101.yinzhengjie.org.cn ~]# mysql -u hive -pyinzhengjie -h cdh101.yinzhengjie.org.cn
Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MariaDB connection id is 13
Server version: 5.5.64-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

MariaDB [(none)]> 
MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| hive               |
+--------------------+
rows in set (0.00 sec)

MariaDB [(none)]> 
MariaDB [(none)]> QUIT
Bye
[root@cdh101.yinzhengjie.org.cn ~]# 
[root@cdh101.yinzhengjie.org.cn ~]#