mysql8.0.15安装

一、下载rpm包 解压

# wget http://mirrors.163.com/mysql/Downloads/MySQL-8.0/mysql-8.0.15-1.el7.x86_64.rpm-bundle.tar

二、安装
1.查看是否以前安装过mariadb,若按安装 则需要先卸载

# rpm -qa|grep mariadb			#查看是否安装
mariadb-libs-5.5.56-2.el7.x86_64
# rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps     #卸载

#依次安装
# rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm 
# rpm -ivh mysql-community-libs-8.0.15-1.el7.x86_64.rpm
# rpm -ivh mysql-community-client-8.0.15-1.el7.x86_64.rpm
# rpm -ivh mysql-community-server-8.0.15-1.el7.x86_64.rpm

三、初始化
1.设置密码简单化

mysql> set global validate_password.policy=0;
mysql> set global validate_password.mixed_case_count=1;
mysql> set global validate_password.length=1;

2.设置root密码

mysql> ALTER USER 'root'@'localhost' identified by '123456';

3.添加普通用户并授权

mysql> create database sxg;
mysql> create user 'sxg'@'%' identified by 'sxg123'
mysql> grant all on sxg.* to 'sxg'@'%' with grant option;

此时如果使用navacat连接会报错: 2059 - authentication plugin 'caching_sha2_password
解决方法一

mysql> alter user 'sxg'@'%' IDENTIFIED WITH mysql_native_password BY 'sxg123'

解决方法二： 在创建用户时添加选项

mysql> create database sun;
mysql> create user 'sun'@'%' identified with mysql_native_password by 'sun123';
mysql> grant all on sun.* to 'sun'@'%' with grant option;