放上来做一个备份，免得忘了密码，囧~
mysql> create database metastore default character set utf8; Query OK, 1 row affected (0.00 sec) mysql> create user ‘hive‘@‘%‘ identified by ‘123456‘; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on metastore.* to ‘hive‘@‘%‘; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql>
其他的组件也可以由默认的postgresql改为mysql，步骤都是建库、建账号、赋权。
原文：http://www.cnblogs.com/larryzeal/p/6657549.html