1 mysql下载：

1 、mysql社区版下载地址：https://downloads.mysql.com/archives/community/

2、 选择product version 5.7.37

3 、linux为centos的话选择 operation system :Red Hat Enterprise Linux/Oracle Linux Os Version:All

4、选择 Red Hat Enterprise Linux 7 / Oracle Linux 7 (x86, 64-bit), RPM Bundle -> Download

2 mysql安装

1、首先清除CentOS7系统中默认的数据库mariadb，否则不能安装mysql

rpm -qa |grep mariadb |xargs yum remove -y

2、将下载的mysql-8.0.28-1.el7.x86_64.rpm-bundle.tar放到/usr/local/mysql目录，解压缩安装包

tar axvf mysql-8.0.28-1.el7.x86_64.rpm-bundle.tar

3、切换到下载包目录下（cd 你的下载目录），然后对每个包按如下顺序着一安装；

方案一：成功
 rpm -ivh mysql-community-common-8.0.28-1.el7.x86_64.rpm
 rpm -ivh mysql-community-libs-8.0.28-1.el7.x86_64.rpm --force --nodeps
 rpm -ivh mysql-community-libs-compat-8.0.28-1.el7.x86_64.rpm 
 rpm -ivh mysql-community-client-8.0.28-1.el7.x86_64.rpm --force --nodeps
 rpm -ivh mysql-community-server-8.0.28-1.el7.x86_64.rpm --force --nodeps

4、安装失败情况

检测本地已经安装的包：rpm -qa | grep mysql
卸载本地已经安装的包：rpm -e --nodeps mysql-community-xx

5、安装完成后，查看已经安装好的组件

rpm -qa | grep mysql

6、通过以下命令，完成对 mysql 数据库的初始化和相关配置

mysqld --initialize 
chown mysql:mysql /var/lib/mysql -R 
systemctl start mysqld.service systemctl  
enable mysqld

3 mysql启动

1、启动MySql

systemctl start mysqld.service

2、停止MySql

systemctl stop mysqld.service

3、重启MySql

systemctl restart mysqld.service

4、设置MySql开机自启

systemctl enable mysqld

5、通过 cat /var/log/mysqld.log | grep password 命令查看数据库的密码

cat /var/log/mysqld.log | grep password

2019-02-16T09:46:38.945518Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ,#t#dlkOG0j0 以上密码为,#t#dlkOG0j0

#### 4 测试MySql安装是否成功
1、以root用户登录MySql，执行命令

mysql -u root -p   

输入以上命令回车进入，出现输入密码提示
2、输入刚刚查到的密码，进行数据库的登陆，复制粘贴就行，MySQL 的登陆密码也是不显示的

Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 11 Server version: 8.0.15 Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement. mysql>

3、修改密码

use mysql; 密码检查等级，0/LOW、1/MEDIUM、2/STRONG set global validate_password.policy=0; a、 密码的最短长度 set global validate_password.length=6; b、密码至少要包含的小写字母个数和大写字母个数 set global validate_password.mixed_case_count=0; c、 设置密码 – ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘gzjbimbjpt@123’; –远程无法访问会出现Authentication plugin ‘caching_sha2_password’ cannot be loaded’问题

– ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘gzjbimbjpt@123’; – ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘gzjbimbjpt@123’;

4、通过 exit; 命令退出 MySQL，然后通过新密码再次登陆
至此，mysql8.0.15数据库就安装完成了。

#### 5 MySql远程访问授权配置
1、以root用户登录MySql

mysql -u root -p   

2、以root用户登录MySql

USE mysql; UPDATE mysql.user SET host = ‘%’ WHERE user = ‘root’; flush privileges; SELECT host, user FROM user;

3、（暂且无用）使root（也可以配置其他的用户，如hadoop）用户可以操作数据库hive中的所有表

create user ‘root’@’%’ identified with mysql_native_password by ‘xhw888’; grant all privileges on . to ‘root’@’%’ with grant option; flush privileges; ``` 附： 创建新用户： CREATE USER ‘用户名’@‘host名称’ IDENTIFIED WITH mysql_native_password BY ‘密码’;

给新用户授权：GRANT ALL PRIVILEGES ON . TO ‘用户名’@‘host名称’;

刷新权限： FLUSH PRIVILEGES;