[...]

Enter current password for root (enter for none):

OK, successfully used password, moving on...

[...]

Set root password? [Y/n] y

New password:hadoophive

Re-enter new password:hadoophive

Remove anonymous users? [Y/n] Y

[...]

Disallow root login remotely? [Y/n] N

[...]

Remove test database and access to it [Y/n] Y

[...]

Reload privilege tables now? [Y/n] Y

All done!

$ mysql -u root –p chengyeliang

mysql> CREATE DATABASE metastore;

mysql> USE metastore;

mysql> SOURCE /usr/lib/hive/scripts/metastore/upgrade/mysql/hive-schema-0.10.0.mysql.sql;

mysql> CREATE USER 'hive'@'%' IDENTIFIED BY 'chengyeliang';

mysql> CREATE USER 'hive'@'localhost' IDENTIFIED BY 'chengyeliang';

mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'hive'@'%';

mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'hive'@'localhost';

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES,EXECUTE ON metastore.* TO 'hive'@'%';

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,LOCK TABLES,EXECUTE ON metastore.* TO 'hive'@'localhost';

mysql> FLUSH PRIVILEGES;

mysql> quit;

 <?xml version="1.0"?>

 <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

 <configuration>

   <property>

     <name>javax.jdo.option.ConnectionURL</name>

     <value>jdbc:mysql://10.127.130.199:3306/metastore?useUnicode=true&amp;characterEn

 coding=UTF-8</value>

     <description>JDBC connect string for a JDBC metastore</description>

   </property>

   <property>

     <name>javax.jdo.option.ConnectionDriverName</name>

     <value>com.mysql.jdbc.Driver</value>

     <description>Driver class name for a JDBC metastore</description>

   </property>

   <property>

     <name>javax.jdo.option.ConnectionUserName</name>

     <value>hive</value>

     <description>username to use against metastore database</description>

   </property>

 <property>

     <name>javax.jdo.option.ConnectionPassword</name>

     <value>chengyeliang</value>

     <description>password to use against metastore database</description>

   </property>

   <property>

    <name>localhost.job.tracker</name>

    <value>localhost:8031</value>

   </property>

   <property>

    <name>mapreduce.framework.name</name>

    <value>yarn</value>

   </property>

   <property>

           <name>hive.metastore.uris</name>

           <value>thrift://localhost:9083</value>

           </property>

           <property>

           <name>hive.metastore.client.socket.timeout</name>

           <value>3600</value>

           <description>MetaStore Client socket timeout in seconds</description>

           </property>

 </configuration>