Centos7快速安装Mysql8.0

时间：2021-03-25作者：klpeng分类：数据库浏览：444评论：0

yum localinstall https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

yum install mysql-community-server

service mysqld start

vim /var/log/mysqld.log   #取默认密码

先重置密码为大小写加符号加数字

alter user user() identified by 'Ab123456.#';

SHOW VARIABLES LIKE 'validate_password%';

set global validate_password.policy=LOW;

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

后续流程正常，create database, create user, grant

解决低版本navicat没有sha2_password加密扩展支持：

use mysql;

select user,host,plugin,authentication_string from user;

update user set authentication_string='' where user='xxx';

alter user 'xxx'@'%' identified with mysql_native_password by 'ab123456';

搭建完成，修改配置文件

继续浏览有关 Centos7快速安装Mysql8.0 的文章