CentOS7使用yum安装MySQL8 「爱情、让人受尽委屈。」 2022-04-23 12:00 214阅读 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
还没有评论,来说两句吧...