安装CDH时关于MySQL的配置

最新推荐文章于 2024-03-10 15:00:00 发布
最新推荐文章于 2024-03-10 15:00:00 发布
阅读量2.6k 收藏
点赞数
分类专栏： cdh之MySQL部分 文章标签： CDH
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_44772799/article/details/98736387
版权

安装配置MySQL 

rpm -qa|grep mariadb

rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

/usr/share/java驱动目录  mv mysql-connector-java-5.1.7-bin.jar mysql-connector-java.jar /usr/share/java

 

启动MySQL：service  mysql  start

设置密码：set password=password('root');

进入MySQL：

[root@cdh228 schema]# mysql -uroot -proot

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 41

Server version: 5.5.59 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE scm DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

Query OK, 1 row affected (0.00 sec)

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

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@' hadoop231' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'127.0.0.1' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'scm'@'localhost' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'scm'@'hadoop231' identified by 'scm' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'scm'@'hadoop231' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'scm'@'127.0.0.1' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'scm'@'%' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

Bye

 

 

然后运行：

在这个目录下 /opt/cloudera-manager/cm-5.9.0/share/cmf/schema

[root@cdh228 schema]# ./scm_prepare_database.sh mysql -h cdh228 -uroot -proot --scm-host cdh228 scm scm

./scm_prepare_database.sh mysql -h hadoop231 -uroot -proot --scm-host hadoop231 scm scm

Enter SCM password:

JAVA_HOME=/usr/java/jdk1.7.0_67-cloudera

Verifying that we can write to /opt/cloudera-manager/cm-5.9.0/etc/cloudera-scm-server

Creating SCM configuration file in /opt/cloudera-manager/cm-5.9.0/etc/cloudera-scm-server

Executing:  /usr/java/jdk1.7.0_67-cloudera/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/share/java/oracle-connector-java.jar:/opt/cloudera-manager/cm-5.9.0/share/cmf/schema/../lib/* com.cloudera.enterprise.dbutil.DbCommandExecutor /opt/cloudera-manager/cm-5.9.0/etc/cloudera-scm-server/db.properties com.cloudera.cmf.db.

[                          main] DbCommandExecutor              INFO  Successfully connected to database.

All done, your SCM database is configured correctly!

 

 

应该会报错（执行删库）：

mysql> drop database scm;

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

再执行：

./scm_prepare_database.sh mysql -h hadoop231 -uroot -proot --scm-host hadoop231 scm scm

安装配置MySQL  systemctl enable mysqld.service  开机启动

rpm -qa|grep mariadb

rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

/usr/share/java驱动目录  mv mysql-connector-java-5.1.7-bin.jar mysql-connector-java.jar /usr/share/java

 

启动MySQL：service  mysql  start

设置密码：set password=password('root');

进入MySQL：

[root@cdh228 schema]# mysql -uroot -proot

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 41

Server version: 5.5.59 MySQL Community Server (GPL)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE scm DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

Query OK, 1 row affected (0.00 sec)

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

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'localhost' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@' hadoop231' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'127.0.0.1' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'scm'@'localhost' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'scm'@'hadoop231' identified by 'scm' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'scm'@'hadoop231' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'scm'@'127.0.0.1' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> grant all privileges on *.* to 'scm'@'%' identified by 'root' with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

Bye

 

 

然后运行：

/opt/cloudera-manager/cm-5.9.0/share/cmf/schema

[root@cdh228 schema]# ./scm_prepare_database.sh mysql -h cdh228 -uroot -proot --scm-host cdh228 scm scm

./scm_prepare_database.sh mysql -h hadoop231 -uroot -proot --scm-host hadoop231 scm scm

Enter SCM password:

JAVA_HOME=/usr/java/jdk1.7.0_67-cloudera

Verifying that we can write to /opt/cloudera-manager/cm-5.9.0/etc/cloudera-scm-server

Creating SCM configuration file in /opt/cloudera-manager/cm-5.9.0/etc/cloudera-scm-server

Executing:  /usr/java/jdk1.7.0_67-cloudera/bin/java -cp /usr/share/java/mysql-connector-java.jar:/usr/share/java/oracle-connector-java.jar:/opt/cloudera-manager/cm-5.9.0/share/cmf/schema/../lib/* com.cloudera.enterprise.dbutil.DbCommandExecutor /opt/cloudera-manager/cm-5.9.0/etc/cloudera-scm-server/db.properties com.cloudera.cmf.db.

[                          main] DbCommandExecutor              INFO  Successfully connected to database.

All done, your SCM database is configured correctly!

 

 

应该会报错（执行删库）：

mysql> drop database scm;

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

再执行：

./scm_prepare_database.sh mysql -h hadoop231 -uroot -proot --scm-host hadoop231 scm scm

年月日朝朝暮暮
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
CDH 04.MySQL5.7安装配置
80后大叔爱学习
10-21 219
1、创建文件目录 mkdir -p /DATA/disk1/software/mysql/; cd /DATA/disk1/software/mysql/; 2、下载mysql5.7包 wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.30-1.el7.x86_64.rpm-bundle.tar; 3、解压缩 tar -xvfmysql-5.7.30-1.el7.x86_64.rpm-bundle.tar 4、删除 mariadb-l.
CDH大数据平台搭建之MYSQL安装
qq_41924766的博客
06-10 385
CHD大数据平台搭建之MYSQL安装一、MYSQL安装1.检查是否安装mysql2.基于yum安装2.基于rpm包安装1、下载rpm包2、安装3.mysql服务命令4.开机自启5.查看初始密码6.登录mysql7.修改密码8.删除其他登录9.授权所有机器登录10.刷新权限 一、MYSQL安装 1.检查是否安装mysql rpm -qa | grep mysql 2.基于yum安装 1.检查当前环境是否已安装MySQL rpm -qa | grep mysql 2.安装MySQL yum instal
CDH安装中Mysql配置
菜鸟的博客
07-14 683
MySQL安装配置
CDH 配置Mysql高可用：主从和keepalived
wumiqing1的博客
12-19 986
问题描述：配置CDH 配置Mysql高可用，并实现和cdh无缝对接。 主从和keepalived配置步骤：网上很多，这里就不多赘述了!   配置常用命令： 查询mysql连接使用的是那台服务器： show variables like "%hostname%"; service keepalived restart service mysqld restart service mysq...
Centos6离线安装CDH5.14.2最全详细教程-6配置Mysql
荒野雄兵的专栏
06-10 3627
概述 配置Mysql数据库 为Cloudera Manager配置Mysql数据库 概述 文章写得很详细，很长，所以这里分成了7个部分 这里是第四部分 记得先看下第一部分的概述 Centos6离线安装CDH5.14.2最全详细教程-1前言 这里再强调一下注意事项 1. 所有步骤如无特别说明都是要在所有服务器上都执行一遍 2. 所有的准备工作都要做，不要漏了或者错了...
CDH和Mysql安装脚本
03-19
CDH的安装通常涉及多个步骤，包括环境配置、JDK安装、CM(Cloudera Manager)准备、CM安装、CDH组件安装等。此脚本可能涵盖以下内容： 1. **环境检查**：首先，脚本会检查操作系统版本、硬件配置以及必备软件（如JDK...
大数据平台CDH6.2.0安装部署
10-27
该过程包括安装Cloudera Manager Server、配置MySQL数据库、部署CDH Parcel文件、配置Cloudera Manager Agent等步骤。 一、安装Cloudera Manager Server Cloudera Manager Server是大数据平台的核心组件，负责管理...
【Centos7.6安装CDH6.1.0】第二节 JDK、Mysql配置
01-07
【Centos7.6安装CDH6.1.0】手把手教你搭建CDH6.1.0JDK（已安装者跳过）mysql配置安装jdbc建库、建用户、设置用户访问权限跳转 JDK（已安装者跳过） 下载linux适用版jdk ... 下载后分发至mini1、mini2、mini3，解压，...
CDH5.14.0安装配置优化文档。
11-05
本人自己的CDH5.14.0的安装记录，保存LINUX配置，MYSQL安装，所有过程记录，以及优化记录。
Redhat7.6安装CDH6.3.3.pdf
11-16
CDH需要一个支持其服务的数据库，如MySQL或PostgreSQL，根据官方文档进行安装和配置。 ### 3. 集群的部署安装 #### 3.1. 安装并启动Cloudera Manager Server 首先，在一个节点上安装Cloudera Manager Server，它是...
CDH MySQL 5.7.24 安装、my.cnf配置文件
Sunshine
06-30 1264
1.查看是否安装了自带mysql： rpm -qa | grep mysql rpm -qa | grep mariadb 如果有，使用以下命令卸载 rpm -e --nodeps xxx 2.把64位的MySQL（centOS 7 版本MySQL：mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz）解压到 /usr/local 目录文件夹下.备注说明:xx...
cdh 安装mysql_CDH准备（CentOS7安装MySQL）
weixin_35009071的博客
01-19 114
#CentOS7安装MySQL1.安装前准备2)卸载系统自带的mariaDB[root@cdhmasterDesktop]# rpm -qa|grep mariadbmariadb-libs-5.5.44-2.el7.centos.x86_64[root@cdhmasterDesktop]# rpm -e --nodeps mariadb-libs-5.5.44-2.el7.centos.x8...
CDH6.0、6.1篇：2、MySQl配置文件my.cnf
laughing1997的博客
03-29 775
此处针对mysql的配置进行说明 两个文件： /etc/my.cnf 不带注释的配置信息 /etc/my.cnf 带注释的配置信息 -----------------分割线---------------------------------------------------------------------- /etc/my.cnf 不带注释的配置信息 [client] port = 3306 ...
cdh mysql_CDH 依赖的MySQL 数据库安装配置说明
weixin_42522167的博客
01-18 1028
1 背景说明根据CDH 官网文档的说明，CDH的如下组件必须有数据库的支持才能运行: Cloudera Manager Server, Oozie Server, Sqoop Server, Activity Monitor, Reports Manager, Hive Metastore Server, Hue Server, Sentry Server, Cloudera Navigator ...
CDH集群离线搭建(适用内网)——mysql离线安装配置④
最新发布
M_red的博客
03-10 376
关于mysql主从最好在cm安装之前就做好。
cdh mysql配置_CDH 配置Mysql高可用：主从和keepalived
weixin_33649132的博客
02-06 412
问题描述：配置CDH 配置Mysql高可用，并实现和cdh无缝对接。主从和keepalived配置步骤：网上很多，这里就不多赘述了!配置常用命令：查询mysql连接使用的是那台服务器：show variables like "%hostname%";service keepalived restartservice mysqld restartservice mysqld stopps -ef |...
cdh5 mysql中保存啥,CDH5.13.3安装手册
weixin_39740272的博客
03-12 90
Server端需要打开端口7180 7182选址正确的版本，cdh版本不要高于cm版本CM下载地址CDH下载地址http://archive.cloudera.com/cdh5/parcels/5.13.3/manifest.json二 安装JAVA环境三 关闭防火墙以及selinux四 配置NTP服务五 设置swap空间(Cloudera建议将交换空间设置为0，过多的交换空间会引起GC耗时的激增...
CDH mysql 元数据库备份
peidezhi的专栏
07-01 625
1 前言mysql-client和mysql-server mysql-client操作mysql实例的客户端有很多，mysql-client只是其中一种，包括mysql，mysqldump，mysqlslap，这些访问，备份，压力测试的工具。 mysql-server是服务端，也就是说，你服务端没安装，客户端没对象去操作。 2 安装mysql-client端元 2.1 先卸载marial db的库包 rpm -qa|grep mariadb rpm -e --nodeps maria...
安装cm初始脚本配置数据库scm_prepare_database.sh(在主节点上)遇到的问题
geomon的博客
01-29 5549
修改MySQL的root用户的密码以及打开远程连接 mysql>use mysql; mysql>desc user; mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "123";　　//为root添加远程连接的能力。 mysql>update user set Password = password(...
CDH6.2-完整版安装文档.doc
02-26
CDH、Cloudera集群搭建详细步骤文档

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值