7. [Optional] Install MySQL

If you are installing Hive and HCatalog services, you need a MySQL database instance to store metadata information. You can either use an existing MySQL instance or install a new instance of MySQL manually. To install a new instance:

  1. Connect to the host machine you plan to use for Hive and HCatalog.

  2. Install MySQL server. From a terminal window, type:

    For RHEL/CentOS: [6.x only supported for Beta]

    yum install mysql-server
  3. Start the instance.

    /etc/init.d/mysqld start

  4. Set the root user password.

    mysqladmin -u root password ‘{password}’
  5. Remove unnecessary information from log and STDOUT.

    mysqladmin -u root 2>&1 >/dev/null
  6. As root, use mysql (or other client tool) to create the “dbuser” and grant it adequate privileges. This user provides access to the Hive metastore.

    CREATE USER '$dbusername'@'%' IDENTIFIED BY '$dbuserpassword';
    GRANT ALL PRIVILEGES ON *.* TO '$dbusername'@'%';
    flush privileges;
  7. See if you can connect to the database as that user. You are prompted to enter the $dbuserpassword password above.

    mysql -u $dbusername -p
  8. Install the MySQL connector JAR file:

    yum install mysql-connector-java*


loading table of contents...