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:
Connect to the host machine you plan to use for Hive and HCatalog.
Install MySQL server. From a terminal window, type:
yum install mysql-server
Start the instance.
/etc/init.d/mysqld start
Set the
root
user password.mysqladmin -u root password ‘{password}’
Remove unnecessary information from log and STDOUT.
mysqladmin -u root 2>&1 >/dev/null
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;
See if you can connect to the database as that user. You are prompted to enter the
$dbuserpassword
password above.mysql -u $dbusername -p
Install the MySQL connector JAR file:
yum install mysql-connector-java-5.0.8-1