Create a database and account for cm-hive using MySQL

Put it up to make a backup, lest you forget the password, embarrassed ~

Mysql>CREATE DATABASE metastore default character set UTF8; Query OK,1Row affected (0.00sec) MySQL> Create User'Hive'@'%'Identified by'123456'; Query OK,0Rows Affected (0.00sec) MySQL> Grant all privileges the metastore.* to'Hive'@'%'; Query OK,0Rows Affected (0.00sec) MySQL>flush Privileges; Query OK,0Rows Affected (0.00sec) MySQL>

Other components can also be changed from the default PostgreSQL to MySQL, the steps are to build a library, build accounts, empowerment.

Create a database and account for cm-hive using MySQL