CentOS 8下安装MySQL8.0

深藏阁楼爱情的钟 2022-02-24 08:46 307阅读 0赞

## 软件版本 ##

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

## 安装MySQL ##

1、下载mysql的yum仓库，[下载地址][Link 1]  
2、选择适合的版本，点击Download，将下载地址复制下来  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0YXJsZW1vbjIwMTY_size_16_color_FFFFFF_t_70_pic_center]

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.*"

![在这里插入图片描述][20201217190251840.png_pic_center]  
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  
    ![在这里插入图片描述][20190404095653291.png]
 *  问题分析：‘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  
    ![在这里插入图片描述][20190404101445554.png]
 *  问题分析：密码校验策略太强了
 *  解决方法：

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

[Link 1]: https://dev.mysql.com/downloads/repo/yum/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N0YXJsZW1vbjIwMTY_size_16_color_FFFFFF_t_70_pic_center]: /images/20220224/e2e5928bdf9d4d6084e071b1693bda06.png
[20201217190251840.png_pic_center]: /images/20220224/d1efb98bd9544667a1e67b6cc52a2390.png
[20190404095653291.png]: /images/20220224/e72e1f489cee407e99906a3f124e1f13.png
[20190404101445554.png]: /images/20220224/3d281d5fa2284fdab40724eafddba28e.png