【重磅推荐】关于centos7配置mysql完整配置【太多坑了，一个一个解析】

川长思鸟来 2021-08-30 21:34 310阅读 0赞

### **关于centos7配置mysql【太多坑了，一个一个解析】** ###

### **第一步：正常安装mysql：** ###

[https://blog.csdn.net/weixin\_43343144/article/details/104995459][https_blog.csdn.net_weixin_43343144_article_details_104995459]第二步：登录设置密码或忘记密码：mysql -u root -p  
关于密码的设置，默认必须是复杂密码，否则会报错【请参考以下文字配置】：

centos7下忘记mysql5.7密码：[https://www.cnblogs.com/yanziwen/p/9215264.html][https_www.cnblogs.com_yanziwen_p_9215264.html]

MySQL如果提示密码过期，请使用使用ALTER USER修改密码：[http://www.hxstrive.com/article/728.htm][http_www.hxstrive.com_article_728.htm]

set global validate_password_policy=0;
    
    set global validate_password_length=1;
    
    # 密码永不过期
    【mysql57之前旧版本重置方法】alter user 'root'@'localhost' identified by '123456' password expire never;
    
    或
    
    【msyql57之后版本的重置方法】set password=password("youpassword");

### **第三步：必须开通远程访问权限：** ###

**开启远程权限之前可能出现的错误【必须先重置密码】：**

**【操作之前请先重置密码，让密码更加复杂】初始化密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before：**[https://www.cnblogs.com/incognitor/p/10780166.html][https_www.cnblogs.com_incognitor_p_10780166.html]

mysql5.7初始化密码报错 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before[https://blog.csdn.net/memory6364/article/details/82426052][https_blog.csdn.net_memory6364_article_details_82426052]

**开始远程权限参考：**  
参考：[https://www.cnblogs.com/dbdd/p/7239002.html][https_www.cnblogs.com_dbdd_p_7239002.html]  
参考：[https://www.cnblogs.com/weifeng1463/p/7941625.html][https_www.cnblogs.com_weifeng1463_p_7941625.html]

# 第一步：登录mysql
    mysql -u root -p
    
    
    use mysql
    
    
    update user set host = '%' where user = 'root';
    
    
    flush privileges ;
    
    quit
    
    重启mysql

开启远程权限常见错误：MySql出现ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'：参考：[https://blog.csdn.net/yuanhong55/article/details/75000208][https_blog.csdn.net_yuanhong55_article_details_75000208]

一切配置好之后，防火墙关闭或打开配置运行后，依然无法连接，连接超时，请参考【重启路由器试试】：[https://blog.csdn.net/weixin\_43343144/article/details/107830117][https_blog.csdn.net_weixin_43343144_article_details_107830117]

[https_blog.csdn.net_weixin_43343144_article_details_104995459]: https://blog.csdn.net/weixin_43343144/article/details/104995459
[https_www.cnblogs.com_yanziwen_p_9215264.html]: https://www.cnblogs.com/yanziwen/p/9215264.html
[http_www.hxstrive.com_article_728.htm]: http://www.hxstrive.com/article/728.htm
[https_www.cnblogs.com_incognitor_p_10780166.html]: https://www.cnblogs.com/incognitor/p/10780166.html
[https_blog.csdn.net_memory6364_article_details_82426052]: https://blog.csdn.net/memory6364/article/details/82426052
[https_www.cnblogs.com_dbdd_p_7239002.html]: https://www.cnblogs.com/dbdd/p/7239002.html
[https_www.cnblogs.com_weifeng1463_p_7941625.html]: https://www.cnblogs.com/weifeng1463/p/7941625.html
[https_blog.csdn.net_yuanhong55_article_details_75000208]: https://blog.csdn.net/yuanhong55/article/details/75000208
[https_blog.csdn.net_weixin_43343144_article_details_107830117]: https://blog.csdn.net/weixin_43343144/article/details/107830117