谈谈MYSQL ERROR 1045 错误的解决办法！

深碍√TFBOYSˉ_ 2021-09-17 11:54 468阅读 0赞

N久没重做win7系统了，昨天重做了一下，之后就是配置环境。apache/PHP都很顺利，唯独mysql，装到最后提示：

![0c7747524ef4e4440df3e3c6.png][]

[![bc819d906bd5e5c7a877a4c6][]][bc819d906bd5e5c7a877a4c6]

The security settings could not be applied to the database because the connection has failed with the following error.  
　　Error Nr. 1045  
　　Access denied for user ['root'@'localhost'][root_localhost] （using password: YES）  
　　If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Otherwise no client application can connect to the server. After you have opened the port please press \[Retry\] to apply the security settings.  
　　If you are re-installing after you just uninstalled the MySQL server please note that the data directory was not removed automatically. Therefore the old password from your last installation is still needed to connect to the server. In this case please select skip now and re-run the Configuration Wizard from the start menu.

关闭各种防火墙依旧无效，无奈点了跳过。然后到控制面板里做了一次修复操作，发现mysql也可以正常使用了。

次日开电脑，发现mysql无法启动了。。修复无效，无奈，卸载，重装，依旧如此提示……

上网查询各种诸如清理注册表，删干净安装目录。均无效！

**最后终于让我找到了靠谱的方案！**

1、mysql -u root
    
    2、use mysql
    
    3、update user set password=old_password('scf') where user='root' and host='localhost' ;
    
    4、FLUSH PRIVILEGES;

注：这个不是通过开始菜单进入的，要通过cmd，然后转移路径到mysql的bin文件夹下执行！

执行完这个再点刚刚那个错误提示的重试，就会显示通过了~~~

[0c7747524ef4e4440df3e3c6.png]: http://www.wuyunkui.com/wp-content/uploads/2011/03/0c7747524ef4e4440df3e3c6.png
[bc819d906bd5e5c7a877a4c6]: http://www.wuyunkui.com/wp-content/uploads/2011/03/bc819d906bd5e5c7a877a4c6.png
[root_localhost]: mailto:'%20rel=