CentOS 8下安装MySQL8.0

软件版本

1.Linux：CentOS Linux release 8.3.2011
2.MySQL：mysql-8.0.21

安装MySQL

1、下载mysql的yum仓库，下载地址
2、选择适合的版本，点击Download，将下载地址复制下来

3、下载MySQL rpm文件

也可以直接下载下来，用ftp上传到服务器

wget https://repo.mysql.com//mysql80-community-release-el8-1.noarch.rpm

4、安装mysql的yum源

[root@localhost~]# yum localinstall mysql80-community-release-el8-1.noarch.rpm

结果：在/etc/yum.repos.d/目录下生成两个mysql-community开头的repo文件

5、检查mysql源是否安装成功

[root@localhost~]# yum repolist enabled | grep "mysql.*-community.*"

6、禁用CentOS8自带mysql模块

[root@localhost~]# yum module disable mysql

7、使用yum源安装mysql

[root@localhost~]# yum install -y mysql-community-server

登录mysql

// 获取初始密码
[root@localhost~]# grep 'temporary password' /var/log/mysqld.log
// 登录
[root@localhost~]# mysql -uroot -p

修改root密码

alter user 'root'@'localhost' identified by 'Root123+';

备注：如果不先修改初始密码，输入任何命令都会报以下错误：
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

如果密码过于简单，会报以下错误：
ERROR 1193 (HY000): Unknown system variable ‘validate_password_policy’

开放远程连接

mysql> show databases;
mysql> use mysql;
mysql> update user set host = "%" where user = "root";

授予所有权限

mysql> grant all privileges on *.* to 'root'@'%';
mysql> flush privileges;

使用Navicat Premium连接报错

• 错误信息：1449:-The user specified as a definer(‘mysql.infoschema’@‘localhost’) does not exist
  mysql.infoschema
  
• 问题分析：‘mysql.infoschema’@'localhost’账户被删除了
• 解决方法：

mysql> SET GLOBAL innodb_fast_shutdown = 1;
[root@localhost~]# mysql_upgrade -u root -p

修改密码时报错

• 错误信息：1819-Your password does not satisfy the current policy requirements
  
• 问题分析：密码校验策略太强了
• 解决方法：

// 1、查看当前安全变量值
mysql> SHOW VARIABLES LIKE 'validate_password%';
// 2、修改变量
mysql> SET GLOBAL validate_password.policy = 0;
mysql> SET GLOBAL validate_password.length = 4;