mysql8 安装

yum -y install  mysql-8.0.18/*

systemctl   start  mysqld

mysql -uroot -p'63EtDw.!PlUD'

ALTER USER 'root'@'localhost' IDENTIFIED BY  '123456@qweABC';

set global validate_password.policy=0;

set global validate_password.length=1;

ALTER USER 'root'@'localhost' IDENTIFIED BY  '123456';

create user 'root'@'%' identified by '123456';

grant all privileges on *.* to 'root'@'%'  with grant option;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

创建用户

CREATE USER user1@'x.x.x.x' IDENTIFIED WITH mysql_native_password BY 'xxx';

在先安装mysql8 客户端

sudo rpm -ivh http://dev.mysql.com/get/mysql80-community-release-el7-7.noarch.rpm
sudo yum -y install mysql-community-client-8.0.32-1.el7

conf

[mysqld]
default_authentication_plugin=mysql_native_password
validate_password.policy=0
validate_password.length=1