Mysql-8.0.18 安装教程

为了安装hive，需要使用到mysql，将安装过程记录如下

1. 依赖的rpm下载，
   libaio-0.3.109-13.el7.x86_64.rpm
   perl-Data-Dumper-2.145-3.el7.x86_64.rpm
   numactl-2.0.9-7.el7.x86_64.rpm
   numactl-devel-2.0.9-7.el7.x86_64.rpm
   numactl-libs-2.0.9-7.el7.x86_64.rpm
   http://mirror.centos.org/centos/7/os/x86_64/Packages/libaio-0.3.109-13.el7.x86_64.rpm
   http://mirror.centos.org/centos/7/os/x86_64/Packages/perl-Data-Dumper-2.145-3.el7.x86_64.rpm
   http://rpmfind.net/linux/centos/7.7.1908/updates/x86_64/Packages/numactl-devel-2.0.12-3.el7_7.1.x86_64.rpm
   http://rpmfind.net/linux/centos/7.7.1908/os/x86_64/Packages/numactl-2.0.12-3.el7.x86_64.rpm
   http://rpmfind.net/linux/centos/7.7.1908/os/x86_64/Packages/numactl-2.0.12-3.el7.x86_64.rpm

2. mysql下载，自己选择版本，下载 bundle，教程安装时选择8.0.18
   https://dev.mysql.com/downloads/mysql/
   

3. 上传至服务器一个节点，安装依赖包

rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm
rpm -ivh perl-Data-Dumper-2.145-3.el7.x86_64.rpm
...

如果本机原本就有mariadb相关内容可能会引起冲突，需要卸载mariadb

rpm -qa | grep mariadb
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

4. 上传mysql安装包，安装mysql

rpm -ivh mysql-community-common-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.18-1.el7.x86_64.rpm

5. 初始化、起服务。

mysqld --initialize --user=mysql
cat /var/log/mysqld.log

会为root生成一个临时密码

systemctl start mysqld     #启动mysql
mysql -uroot -p    #输入上面的密码

# 修改password
mysql> alter user 'root'@'localhost' identified by 'qwe123';
Query OK, 0 rows affected (0.01 sec)

6.设置mysql远程访问
进入mysql客户端

mysql> use mysql;
mysql> CREATE USER 'root'@'%' IDENTIFIED BY 'qwe123';
mysql> GRANT ALL ON *.* TO 'root'@'%';
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'qwe123';
mysql> FLUSH PRIVILEGES;

7.测试一下远程连接，成功即可