hive 配置MySQL库
chkconfig mysqld on MySQL开机自启动
建库:
--hive数据库
2
create database hive DEFAULT CHARSET utf8 COLLATE utf8_general_ci
3
--集群监控数据库
4
create database amon DEFAULT CHARSET utf8 COLLATE utf8_general_ci
5
--hue数据库
6
create database hue DEFAULT CHARSET utf8 COLLATE utf8_general_ci
授权并设置密码
grant all on *.* to root@"%" Identified by "hadoop";
为Cloudera Manager 5建立数据库:
/opt/cm-5.0.0/share/cmf/schema/scm_prepare_database.sh mysql cm -hlocalhost -uroot -phadoop --scm-host localhost scm scm scm
从官网上下载最新稳定版:mysql-connector-java-5.1.30.tar.gz,
解压之后找到mysql-connector-java-5.1.30-bin.jar放到/opt/cm-5.0.0/share/cmf/lib/目录下。 开启Cloudera Manager 5 Server端: