cdh_mysql

1、安装mysql
 sudo yum install mysql-server

2、查看mysql的运行状态

  sudo service mysqld status 

3、开机启动

  sudo chkconfig mysqld on 

  sudo chkconfig --list mysqld

4、连接mysql

        mysql -h localhost -u root -p (默认密码为空）

5、修改root密码

     sudo /usr/bin/mysql_secure_installation (password:123456)

6、安装jdbc dirver

tar zxvf mysql-connector-java-5.1.31.tar.gz

sudo cp mysql-connector-java-5.1.31/mysql-connector-java-5.1.31-bin.jar /usr/share/java/mysql-connector-java.jar
sudo mkdir -p /usr/share/java/ (如不存在需要创建）

7、创建db

create database database DEFAULT CHARACTER SET utf8;
grant all on database.* TO 'user'@'%' IDENTIFIED BY 'password'；

Role	Database	User	Password
Activity Monitor	amon	amon	amon_password
Reports Manager	rman	rman	rman_password
Hive Metastore Server	metastore	hive	hive_password
Sentry Server	sentry	sentry	sentry_password
Cloudera Navigator Audit Server	nav	nav	nav_password
Cloudera Navigator Metadata Server	navms	navms	navms_password

create database amon default character utf8;

grant all on amon.* to 'amon'@'%'  identified by 'amon_password';

create database rman default character utf8;

grant all on rman.* to 'rman'@'%'  identified by 'rman_password';

8、HUE

create database hue default character utf8;

grant all on hue.* to 'hue'@'%'  identified by 'secretpassword';

9、OOZIE

create database OOZIE default character utf8;

grant all on oozie.* to 'oozie'@'%'  identified by 'oozie';