上一篇博文我们讲了hive的操作,并且知道默认的derby数据库不支持并发执行,因此我们选用Mysql存储Metastore。那么这篇博文带来的是如何安装Mysql。
本系列所用到的安装包博主已经上传到百度云盘中,如有需要的可以自取。下面为链接: 链接:https://pan.baidu.com/s/10ezDJTuZl-qU2sq0hDCinw 提取码:pw12
注意:这些步骤推荐切换成root账户进行操作,否则可能会出现权限不够的问题
[root@hadoop001 hive]# rpm -qa|grep mysql
[root@hadoop001 hive]# rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64
[root@hadoop001 software]# unzip mysql-libs.zip
[root@hadoop001 software]# cd mysql-libs
[root@hadoop001 mysql-libs]# ll
[root@hadoop001 mysql-libs]# rpm -ivh MySQL-server-5.6.24-1.el6.x86_64.rpm
[root@hadoop001 mysql-libs]# cat /root/.mysql_secret
# The random password set for the root user at Wed Apr 29 03:39:39 2020 (local time): 7dr8pq16R7q7k4XD
[root@hadoop001 mysql-libs]# service mysql status
[root@hadoop001 mysql-libs]# service mysql start
[root@hadoop001 mysql-libs]# rpm -ivh MySQL-client-5.6.24-1.el6.x86_64.rpm
[root@hadoop001 mysql-libs]# mysql -uroot -p7dr8pq16R7q7k4XD
mysql>SET PASSWORD=PASSWORD('000000');
mysql>exit
配置只要是root用户+密码,在任何主机上都能登录MySQL数据库。
[root@hadoop001 mysql-libs]# mysql -uroot -p000000
mysql>show databases;
mysql>use mysql;
mysql>show tables;
mysql>desc user;
mysql>select User, Host, Password from user;
mysql>update user set host='%' where host='localhost';
mysql>delete from user where Host='hadoop001';
mysql>delete from user where Host='127.0.0.1';
mysql>delete from user where Host='::1';
mysql>flush privileges;
mysql>quit;
本次的分享就到这里了