# 查看状态service mysqld status
# stop/startservice mysqld stop
service mysqld start
登录Mysql 修改密码
# 先查看默认密码sudogrep'temporary password' /var/log/mysqld.log
# 用默认密码登录
mysql -u root -p
# 自己测试的环境,密码修改的简单一些。修改密码最小长度策略 (最小为4,比4低也是4)set global validate_password_length=4;# 修改密码强度检查等级策略set global validate_password_policy=0;# 修改密码 我就简单一点123456了set password for'root'@'localhost'= password('123456');# 开启mysql的root用户远程连接服务# 为了日后子节点的hive客户端可以远程连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;# 刷新权限
flush privileges;# 退出mysqlexit;
Result
2. Hive
解压hive源码包
tar -zxvf apache-hive-1.2.2-bin.tar.gz -C /usr/local
配置环境变量
vi etc/profile
## 增加变量export HIVE_HOME=/usr/local/apache-hive-1.2.2-bin
export CLASSPATH=.:${HIVE_HOME}/lib:$CLASSPATHexport PATH=${HIVE_HOME}/bin:${HIVE_HOME}/conf:$PATH
修改hive配置文件
cd /usr/local/apache-hive-1.2.2-bin/conf/
vi hive-site.xml
# 修改hive配置文件<configuration>#JDBC的连接URL<property><name>javax.jdo.option.ConnectionURL</name><value>jdbc:mysql://192.168.31.60:3306/hive</value><description>JDBC connect string for a JDBC metastore</description></property>#数据库账号密码<property><name>javax.jdo.option.ConnectionUserName</name><value>root</value></property><property><name>javax.jdo.option.ConnectionPassword</name><value>123456</value></property><property><name>javax.jdo.option.ConnectionDriverName</name><value>com.mysql.jdbc.Driver</value></property><property><name>hive.exec.scratchdir</name><value>/usr/local/apache-hive-1.2.2-bin/tmp</value></property><property><name>hive.metastore.warehouse.dir</name><value>/usr/local/apache-hive-1.2.2-bin/warehouse</value></property><property><name>hive.downloaded.resources.dir</name><value>/usr/local/apache-hive-1.2.2-bin/downloaded</value></property><property><name>hive.exec.local.scratchdir</name><value>/usr/local/apache-hive-1.2.2-bin/scratchdir</value></property></configuration>