二:mysql的安装
2.1:centos7默认安装的是mariadb,需要先卸载mariadb,先查看是否安装mariadb
rpm -qa | grep mariadb
如果找到,则拷贝结果,使用下面命令删除,如删除mariadb-libs-5.5.35-3.el7.x86_64
rpm -e --nodeps mariadb-libs-5.5.35-3.el7.x86_64
2.2 查找以前是否安装有mysql卸载,使用下面命令:
1:rpm -qa|grep -i mysql
如果已安装,则需要删除已安装的数据库,使用以下命令来删除数据库
删除命令:rpm -e --nodeps 包名
2.删除老版本mysql的开发头文件和库
命令:rm -fr /usr/lib/mysql
rm -fr /usr/include/mysql
3.注意:卸载后/var/lib/mysql中的数据及/etc/my.cnf不会删除,如果确定没用后就手工删除
rm -f /etc/my.cnf
rm -fr /var/lib/mysql
2.3 mysql安装包MySQL-server-5.6.24-1.el6.x86_64.rpm,
MySQL-client-5.6.24- 1.el6.x86_64.rpm,mysql-connector-java-5.1.27.tar.gz
yum -y install autoconf
1:安装服务端 rpm -ivh MySQL-server-5.6.24-1.el6.x86_64.rpm
2:查看临时密码 cat /root/.mysql_secret
密码为:Tn4l7JX18KV2vR8q
3:安装客户端 rpm -ivh MySQL-client-5.6.24-1.el6.x86_64.rpm
4:临时登录修改密码 mysql -uroot -pTn4l7JX18KV2vR8q
mysql> SET PASSWORD=PASSWORD('123456');
mysql>quit;
5: 再次进入mysql mysql -uroot -p123456
mysql>use mysql;
mysql>select User, Host, Password from user;
mysql>delete from user where Host='hadoop112';
mysql>delete from user where Host='127.0.0.1';
mysql>delete from user where Host='::1';
mysql>select User, Host, Password from user;
mysql>flush privileges;
mysql>quit;
2.4Hive 元数据配置到 MySql,
cp ./mysql-connector-java-5.1.27-bin.jar /opt/module/hive-1.2.1/lib/
在hive的conf目录下创建hive-site.xml vim 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://hadoop112: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>
#mysql用户名
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>username to use against metastore database</description>
</property>
#mysql密码
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
<description>password to use against metastore database</description>
</property>
</configuration>