第四篇 hiv安装-【1】安装MySQL【yum方式】
检查节点中是否自带mysql：
rpm -qa | grep mysql
rpm -qa | grep mariadb
如果有安装，需要卸载系统自带：
rpm -e mysql【一般删除，如果提示以来的其他文件，则不能删除】
rpm -e --nodeps mysql【强制删除，包含各种依赖包】
yum -y remove mysql* 【删除软件的时候会删除对该软件具有依赖关系的包】
【Tips：三种方式任选】
下载 mysql57-community-release-el7-9.noarch.rpm 的yum源：
wget http://mirrors.ustc.edu.cn/mysql-repo/mysql57-community-release-el7-9.noarch.rpm
安装rpm文件：
rpm -ivh mysql57-community-release-el7-9.noarch.rpm
yum安装mysql-community-server
yum -y install mysql-community-server
关闭强密码验证：
vim /etc/my.cnf
# 增加如下内容
plugin-load=validate_password.so
validate-password=OFF
启动mysql服务：
service mysqld start
获取随机密码：
[root@master ~]# grep "password" /var/log/mysqld.log
[Note] A temporary password is generated for root@localhost: r+RWXg*a7e%1
更改密码,进入mysql;
mysql -u root -p
mysql> SET PASSWORD = PASSWORD('123456');
mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
mysql> flush privileges;
查询用户表：
mysql> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select User,authentication_string,Host from user;
+---------------+-------------------------------------------+-----------+
| User | authentication_string | Host |
+---------------+-------------------------------------------+-----------+
| root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | localhost |
| mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | localhost |
| mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | localhost |
+---------------+-------------------------------------------+-----------+
3 rows in set (0.00 sec)
设置任意IP访问：
mysql> grant all privileges on *.* to root@"%" identified by "123456";
mysql> flush privileges;
退出mysql：exit 设置开机启动mysql服务：systemctl enable mysqld
7.安装mysql连接工具
wget https://cdn.mysql.com/archives/mysql-connector-java-5.1/mysql-connector-java-5.1.45.tar.gz
tar -zxvf mysql-connector-java-5.1.45.tar.gz
cd mysql-connector-java-5.1.45
cp mysql-connector-java-5.1.45-bin.jar $HIVE_HOME/lib/
