8.安装MySQL
8.1.检查是否安装mysql服务:
rpm -qa | grep -i mysql
若有则卸载:rpm -e --nodeps mysql-libs-5*
8.2.解压传入的安装包:
unzip mysql-libs.zip
yum -y install unzip
8.3.无法rpm安装mysql的服务端,网上解决方法:
yum install -y perl-Module-Install.noarch
8.4.然后一一安装:
rpm -ivh MySQL-server-5.6.24-1.el6.x86_64.rpm
rpm -ivh MySQL-client-5.6.24-1.el6.x86_64.rpm
9.启动MySQL
9.1.开启服务
service mysql start
9.2.查看初始密码
cat /root/.mysql_secret
9.3.进入界面
mysql -uroot -p加密码
9.4.更改密码
set password=password("hchhch");
10.无主机登录(即为修改user表)
10.1.进入库mysql,表user查询
show databases;
use mysql;
show tables;
desc user;
select User,Host,Password from user;
10.2.修改user表,把Host表的内容修改为%
update user set host="%" where host='localhost';
10.3.删除root用的其他host
delete from user where Host='node01';
delete from user where Host='127.0.0.1';
delete from user where Host='::1';
10.4.刷新
flush privileges;
10.5.退出
quit;
10.6.验证
从node02中登录尝试
11. 配置MetaStore到MySQL
cd /root/app/hive/conf/
vi hive-site.xml(四个属性,密码是自己登录的)
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://node01:3306/metastore?createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hchhch</value>
<description>password to use against metastore database</description>
</property>
</configuration>
12.驱动拷贝
12.1.解压
在/opt/software/mysql-libs目录下解压mysql-connector-java-5.1.27.tar.gz驱动包
tar -zxvf mysql-connector-java-5.1.27.tar.gz
12.2.拷贝
进入一级后拷贝解压出的mysql-connector-java-5.1.27-bin.jar到/root/app/hive/lib/
cp mysql-connector-java-5.1.27-bin.jar /root/app/hive/lib/
12.3.配置
配置完毕后,如果启动hive异常,可以重新启动虚拟机。
(重启后,别忘了启动hadoop集群)
13. 多窗口启动hive测试
13.0.hadoop不要忘记启动
start-dfs.sh
13.1.重新启动数据库,并查看内容库
service mysql start
mysql -uroot -phchhch
show databases;
13.2.在node01中启动hive
再次查看mysql中的内容库 show databases;
会多出来一个“metastore”库,里面有许多表
这个库名就是上面hive-site.xml第一个属性中设置的