CDH集群离线搭建(适用内网)——mysql离线安装配置④

12.mysql离线安装(装一台)

如果是三节点，装在第一个节点即可，如果资源充足（几十个节点），可单独拽出一台用来做mysql数据库节点。

#在cm节点上安装即可
# 离线安装
# 解压安装包

mkdir -p /opt/tools/mysql
tar -xvf mysql-5.7.27-1.el7.x86_64.rpm-bundle.tar -C /opt/tools/mysql


# 删除系统自带的MySQL-libs
yum remove -y mysql-libs

# 安装server时要依赖
yum install -y net-tools

# 离线安装
rpm -vih /opt/tools/mysql/mysql-community-common-5.7.27-1.el7.x86_64.rpm
rpm -vih /opt/tools/mysql/mysql-community-libs-5.7.27-1.el7.x86_64.rpm
rpm -vih /opt/tools/mysql/mysql-community-client-5.7.27-1.el7.x86_64.rpm
yum install -y  /opt/tools/mysql/mysql-community-server-5.7.27-1.el7.x86_64.rpm
rpm -ivh /opt/tools/mysql/mysql-community-libs-compat-5.7.27-1.el7.x86_64.rpm

# 启动MySQL
systemctl start mysqld
systemctl status mysqld


# cat /var/log/mysqld.log | grep password 查看初始化密码

# 登录
mysql -uroot -p
# 输入初始化密码

# 设置校验密码的长度
set global validate_password_policy=LOW; 
# 修改密码
set password=PASSWORD('12345678');
# 对外开放权限
set global validate_password_policy=LOW; 
grant all privileges on *.* to 'root'@'%' identified by '12345678';
flush privileges; 

# 重启生效
systemctl restart mysqld

关于mysql主从最好在cm安装之前就做好

13.mysql元数据库配置

#登录mysql数据库
mysql -uroot -p12345678

set global validate_password_policy=LOW; 
create database metastore default character set utf8;
create user 'hive'@'%' identified by 'hivedemima';
grant all privileges on metastore.* to 'hive'@'%';

create database cm default character set utf8;
create user 'cm'@'%' identified by 'cmdemima';
grant all privileges on cm.* to 'cm'@'%';

create database am default character set utf8;
create user 'am'@'%' identified by 'amdemima';
grant all privileges on am.* to 'am'@'%';

create database rm default character set utf8;
create user 'rm'@'%' identified by 'rmdemima';
grant all privileges on rm.* to 'rm'@'%';

create database hue default character set utf8;
create user 'hue'@'%' identified by 'huedemima';
grant all privileges on hue.* to 'hue'@'%';

create database oozie default character set utf8;
create user 'oozie'@'%' identified by 'ooziedemima';
grant all privileges on oozie.* to 'oozie'@'%';

create database sentry default character set utf8;
create user 'sentry'@'%' identified by 'sentrydemima';
grant all privileges on sentry.* to 'sentry'@'%';

create database nas default character set utf8;
create user 'nas'@'%' identified by 'nasdemima';
grant all privileges on nas.* to 'nas'@'%';

create database nms default character set utf8;
create user 'nms'@'%' identified by 'nmsdemima';
grant all privileges on nms.* to 'nms'@'%';

flush privileges;
exit;

14.jdbc离线安装

#所有节点
#复制MySQL的JDBC包
mkdir /usr/share/java

#主节点执行
sh scp_all.sh mysql-connector-java-5.1.35.jar /tmp/

#所有节点执行
mv /tmp/mysql-connector-java-5.1.35.jar /usr/share/java/
ln -s /usr/share/java/mysql-connector-java-5.1.35.jar /usr/share/java/mysql-connector-java.jar

上一篇
CDH集群离线搭建(适用内网)——jdk离线安装③

下一篇
CDH集群离线搭建(适用内网)——httpd服务、cm服务安装,yum源配置⑤