【重磅推荐】关于Centos7安装、配置、修改密码、远程访问完全配置流程【避免各种坑】

心已赠人 2021-08-30 22:26 247阅读 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**  
关于密码的设置，默认必须是复杂密码，否则会报错【请参考以下文字配置】：  
【操作之前请先重置密码，让密码更加复杂】初始化密码报错 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]  
centos7下忘记mysql5.7密码：[https://www.cnblogs.com/yanziwen/p/9215264.html][https_www.cnblogs.com_yanziwen_p_9215264.html]

特殊情况：mysql错误问题【总是提示密码错误,但控制台mysql -u root -p正常】 1045 (28000): Access denied for user 'root'@'127.0.0.1'：[https://blog.csdn.net/weixin\_43343144/article/details/105025899][https_blog.csdn.net_weixin_43343144_article_details_105025899]

**第三步：必须开通远程访问权限：**  
参考：[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_weixin_43343144_article_details_104995459]: https://blog.csdn.net/weixin_43343144/article/details/104995459
[https_www.cnblogs.com_incognitor_p_10780166.html]: https://www.cnblogs.com/incognitor/p/10780166.html
[https_www.cnblogs.com_yanziwen_p_9215264.html]: https://www.cnblogs.com/yanziwen/p/9215264.html
[https_blog.csdn.net_weixin_43343144_article_details_105025899]: https://blog.csdn.net/weixin_43343144/article/details/105025899
[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