CentOS7使用yum安装MySQL8

「爱情、让人受尽委屈。」 2022-04-23 12:00 266阅读 0赞

### CentOS7使用yum安装MySQL8 ###

1.  wget [http://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm][http_dev.mysql.com_get_mysql80-community-release-el7-2.noarch.rpm]
2.  sudo yum localinstall mysql80-community-release-el7-2.noarch.rpm
3.  yum安装MySQL：sudo yum install mysql-community-server
4.  启动MySQL服务：systemctl start mysqld
5.  检查MySQL服务状态：systemctl status mysqld
6.  修改无密码登录：vim /etc/my.cnf 加入skip-grant-tables
7.  重启MySQL服务
8.  查看当前安全变量值：SHOW VARIABLES LIKE ‘validate\_password%’;![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2EzMzIwNTY5MTg_size_16_color_FFFFFF_t_70]
9.  本地MySQL客户端登录：mysql
10. flush privileges
11. 修改密码： ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘123456’;
12. 其它:  
    ±-------------------------------------±-------+  
    | Variable\_name | Value |  
    ±-------------------------------------±-------+  
    | validate\_password.check\_user\_name | ON |  
    | validate\_password.dictionary\_file | |  
    | validate\_password.length | 6 |  
    | validate\_password.mixed\_case\_count | 1 |  
    | validate\_password.number\_count | 1 |  
    | validate\_password.policy | LOW |  
    | validate\_password.special\_char\_count | 1 |  
    | validate\_password\_check\_user\_name | ON |  
    | validate\_password\_dictionary\_file | |  
    | validate\_password\_length | 8 |  
    | validate\_password\_mixed\_case\_count | 1 |  
    | validate\_password\_number\_count | 1 |  
    | validate\_password\_policy | MEDIUM |  
    | validate\_password\_special\_char\_count | 1 |  
    ±-------------------------------------±-------+  
    可在/etc/my.cnf中添加上面的配置，如下图：  
    ![在这里插入图片描述][2019021814270220.png]

<table> 
 <thead> 
  <tr> 
   <th>Policy</th> 
   <th>Tests Performed</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>0 or LOW</td> 
   <td>Length</td> 
  </tr> 
  <tr> 
   <td>1 or MEDIUM</td> 
   <td>Length; numeric, lowercase/uppercase, and special characters</td> 
  </tr> 
  <tr> 
   <td>2 or STRONG</td> 
   <td>Length; numeric, lowercase/uppercase, and special characters; dictionary file</td> 
  </tr> 
 </tbody> 
</table>

远程连接问题: authentication plugin caching\_sha2\_password  
修改密码：ALTER USER ‘root’@’%’ IDENTIFIED WITH **mysql\_native\_password** BY ‘123456’;

[http_dev.mysql.com_get_mysql80-community-release-el7-2.noarch.rpm]: http://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2EzMzIwNTY5MTg_size_16_color_FFFFFF_t_70]: /images/20220319/3ef327bf32b44325891aa0d46c4e75d4.png
[2019021814270220.png]: /images/20220319/e4bfa9f1ba8a4849a9fa4d0002c2ebf2.png