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

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

　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　作者：尹正杰

一.添加数据库

[root@cdh101.yinzhengjie.org.cn ~]# 
[root@cdh101.yinzhengjie.org.cn ~]# mysql -uroot -pyinzhengjie
Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MariaDB connection id is 18
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 |
| cloudera_manager   |
| hive               |
| mysql              |
| performance_schema |
+--------------------+
5 rows in set (0.01 sec)

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

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

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

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

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

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

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

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

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