【Mysql】Centos8.2 安装 Mysql 8.0

Rpm 方式安装

1、Rpm下载与版本选择地址：https://repo.mysql.com//

在本次安装中不需要从上面的地址下载，只需要选择一个合适的版本，通过 dnf localinstall 设置即可；

2、dnf 方式安装：

如果 dnf install 这一步特别慢，可以通过 国内镜像下载对应版本的 mysql-community-sercer，然后覆盖掉 dnf 的对应缓存（/var/dnf/mysql/）。

http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-8.0/

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

dnf module disable mysql

dnf -y install mysql-community-server

3、修改配置

vim /etc/my.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.0/en/server-configuration-defaults.html

[mysqld]

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


# Ezrealer set,email:Ezrealer@qq.com

character-set-server = utf8mb4

collation-server = utf8mb4_general_ci

bind-address = 0.0.0.0

#只能用IP地址检查客户端的登录，不用主机名
skip_name_resolve = 1

max_connections = 2000

default-time_zone='+8:00'

innodb_buffer_pool_size = 8G
thread_cache_size = 64
innodb_log_file_size = 2G

4、启动mysql 并修改密码

systemctl start mysqld.service  

systemctl status mysqld.service

grep "password" /var/log/mysqld.log

mysql -uroot -p password

# 可选
set global validate_password_policy=0;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'testmysql'；

5、设置远程连接权限

use mysql;

select host, user, authentication_string, plugin from user;

update user set host='%' where user='root';

FLUSH PRIVILEGES;

执行后用 navicat 连接发现报错：

1251-Client does not support authentication protocal requested by server ;consider upgrading mysql client

查找问题后发现：

MySQL8.0之前的版本密码加密规则：mysql_native_password，

MySQL8.0密码加密规则：caching_sha2_password

修改mysql加密规则

ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

 
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '新的密码';

FLUSH PRIVILEGES;

再测试，登录成功！