CDH6.3.2大数据集群生产环境安装(五)之httpd和clouderManagerServer、agent组件安装

15. 数据库用户赋权(CDH6开始弃用scm用户，启用cmf用户，因此scm用户可以不建)
    CREATE DATABASE scm DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
    create USER ‘scm’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘password’;
    grant all privileges on scm.* to ‘scm’@‘%’ with grant option;

CREATE DATABASE cmf DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
create USER ‘cmf’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘password’;
grant all privileges on cmf.* to ‘cmf’@‘%’ with grant option;

CREATE DATABASE amon DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
create USER ‘amon’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘password’;
grant all privileges on amon.* to ‘amon’@‘%’ with grant option;

CREATE DATABASE rman DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
create USER ‘rman’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘password’;