CentOS 8 安装 mysql 8

yum install mysql-server

service mysqld start

service mysqld status

systemctl enable mysqld.service

mysqladmin -uroot -p password
Enter password: # 直接回车
New password:
Confirm new password:
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

# 使用密码登录
mysql -u root -p

# 使用mysql库
use mysql

# 查看认证模式，默认都是localhost
select user,authentication_string,host from user;

# 修改root用户为可远程登录
update user set host='%' where user='root';

# 刷新
flush privileges;

# 使用密码登录
mysql -u root -p

# 使用mysql库
use mysql

# 将MySQL8的密码认证插件由caching_sha2_password更换成mysql_native_password：
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'passowrd';