一、mysql修改簡(jiǎn)單密碼
? ? mysql> set password = password('1234');#設(shè)置密碼
報(bào)錯(cuò):
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
首先彤蔽,修改validate_password_policy參數(shù)的值
mysql> set global validate_password_policy=0;
這樣肩狂,判斷密碼的標(biāo)準(zhǔn)就基于密碼的長(zhǎng)度了柬赐。這個(gè)由validate_password_length參數(shù)來決定柒啤。
validate_password_length參數(shù)默認(rèn)為8机断,可以設(shè)置為其它值,最小4位
mysql> set global validate_password_length=1;
mysql> set password = password('1234');
Query OK, 0 rows affected,1 warning (0.00 sec)
授權(quán)用戶root使用密碼passwd從任意主機(jī)連接到mysql服務(wù)器
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql密碼' WITH GRANT OPTION;
flush privileges;
二趣斤、hive俩块,oozie安裝失敗,無法連接mysql
此處hive 浓领,oozie會(huì)安裝失敗玉凯,因?yàn)槲覀兪褂昧薓ySQL作為hive元數(shù)據(jù)存儲(chǔ),需要將mysql驅(qū)動(dòng)拷貝到hive和oozie目錄下联贩。(所有節(jié)點(diǎn))
cp /opt/cm-5.15.0/share/cmf/lib/mysql-connector-java-5.1.46-bin.jar?/opt/cloudera/parcels/CDH-5.15.1-1.cdh5.15.1.p0.4/lib/hive/lib
cp /opt/cm-5.15.0/share/cmf/lib/mysql-connector-java-5.1.46-bin.jar /var/lib/oozie/
然后重試安裝就可以了
三漫仆、缺少東西
1、pstree: command not found
/opt/cm-5,15.0/etc/init.d/cloudera-scm-server start
/opt/cm-5.15.0/etc/init.d/cloudera-scm-server: line 109:pstree: command not found
Starting cloudera-scm-server: [FAILED]
/opt/cm-5.15.0/etc/init.d/cloudera-scm-agent start
/opt/cm-5.15.0/etc/init.d/cloudera-scm-agent: line 108:pstree: command not found
Starting cloudera-scm-agent: [FAILED]
因?yàn)橄到y(tǒng)是最小化安裝泪幌,默認(rèn)沒有安裝
解決方法
yum install psmisc -y
中途安裝失敗盲厌,重新安裝
關(guān)閉所有服務(wù)
主節(jié)點(diǎn)
$> /opt/cm-5.15.0/etc/init.d/cloudera-scm-server stop
主節(jié)點(diǎn)及其他節(jié)點(diǎn)
$>? /opt/cm-5.15.0/etc/init.d/cloudera-scm-agent stop
刪除agent uuid
rm -rf /opt/cm-5.15.0/lib/cloudera-scm-agent/*
刪除數(shù)據(jù)庫scm
重新配置數(shù)據(jù)庫
/opt/cm-5.15.0/share/cmf/schema/scm_prepare_database.sh mysql -hlocalhost -uroot -p scm scm
啟動(dòng)Cloudera server和agent,按照之前步驟安裝即可
四祸泪,無法找到JAVA_HOME
?JAVA_HOME 并沒有設(shè)置成功,然而在jdk安裝時(shí)設(shè)置了JAVA_HOME 吗浩,而且在linux shell 執(zhí)行 echo $JAVA_HOME ?也是有輸出的, 由于CDH不會(huì)使用系統(tǒng)默認(rèn)JAVA_HOME環(huán)境變量,而是使用Bigtop進(jìn)行管理浴滴,故我們需要安裝Bigtop的規(guī)則在指定的位置安裝jdk拓萌。
配置在這里:/opt/cm-xxx/lib64/cmf/service/common/cloudera-config.sh
其中可以看到:
local JAVA8_HOME_CANDIDATES=(
'/usr/java/jdk1.8'
'/usr/java/jre1.8'
'/usr/lib/jvm/j2sdk1.8-oracle'
'/usr/lib/jvm/j2sdk1.8-oracle/jre'
'/usr/lib/jvm/java-8-oracle'
)
在相應(yīng)的JAVA_HOME下添加自己的JAVA_HOME目錄即可