CDH使用MySQL数据库的使用记录

本人记录了下CDH配置Mysql的问题，仅供自己参看

1.mysql的重要配置文件my.cnf(默认在/etc/my.cnf)，记录了datadir 目录等，

2.datadir 目录记录mysql的安装位置，默认情况下是 /var/lib/mysql，需要位于具有足够可用空间的分区上

3.设置MySQL root密码和其他与安全相关的设置。在新的安装中，根密码为空。

按照/usr/bin/mysql_secure_installation文件进行展示修改密码

4.为Cloudera软件创建数据库

mysql -u root -p

Enter password: 123

Databases for Cloudera Software

Service	Database	User
Cloudera Manager Server	scm	scm
Activity Monitor	amon	amon
Reports Manager	rman	rman
Hue	hue	hue
Hive Metastore Server	metastore	hive
Sentry Server	sentry	sentry
Cloudera Navigator Audit Server	nav	nav
Cloudera Navigator Metadata Server	navms	navms
Oozie	oozie	oozie

 

 

 

 

 

 

 

 

 

 

 

 

 

 CREATE DATABASE scm DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

GRANT ALL ON scm.* TO'scm'@'%'IDENTIFIED BY 'scm';

 

CREATE DATABASE amon DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

GRANT ALL ON amon.* TO'amon'@'%'IDENTIFIED BY 'amon';

 

CREATE DATABASE rman DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

GRANT ALL ON rman.* TO'rman'@'%'IDENTIFIED BY 'rman';

 

CREATE DATABASE hue DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

GRANT ALL ON hue.* TO'hue'@'%'IDENTIFIED BY 'hue';

 

CREATE DATABASE metastore DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

GRANT ALL ON metastore.* TO'hive'@'%'IDENTIFIED BY 'hive';

 

CREATE DATABASE sentry DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

GRANT ALL ON sentry.* TO'sentry'@'%'IDENTIFIED BY 'sentry';

 

CREATE DATABASE nav DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

GRANT ALL ON nav.* TO'nav'@'%'IDENTIFIED BY 'nav';

 

CREATE DATABASE navms DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

GRANT ALL ON navms.* TO'navms'@'%'IDENTIFIED BY 'navms';

 

CREATE DATABASE oozie DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

GRANT ALL ON oozie.* TO 'oozie'@'%' IDENTIFIED BY 'oozie';