在安装mysql时,出现“The security settings could not be applied to the data because the connection has failed with the following error. Error Nr. 1045 Access denied for user \'root\'@\'localhost\' (using password: YES)” 解决办法:
-
在装mysql时,总是到最后启动的时候出错,出错内容如下:
就是最后的Apply security setting过不去
提示:
The security settings could not be applied to the data because the connection has failed with the following error.
Error Nr. 1045
Access denied for user \'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.
解决方法:
1, 首先卸载MySQL
2, 再根据这个目录 C:\\Documents and Settings\\All Users\\Application Data\\MySQL,将mysql删除
3, 重新安装MySQL 就好了(电脑不用重启)
---------------------
作者:dw_java08
来源:CSDN
原文:https://blog.csdn.net/dw_java08/article/details/7326040
版权声明:本文为博主原创文章,转载请附上博文链接!
继续阅读与本文标签相同的文章
-
[集合]Collection源码解析(1)
2026-05-18栏目: 教程
-
300+道面试题&最全面试资料,你值得拥有! | Android面试宝典
2026-05-18栏目: 教程
-
小白学Python | 最简单的Django 简明教程
2026-05-18栏目: 教程
-
Jvm-Sandbox源码分析--模块刷新和卸载
2026-05-18栏目: 教程
-
MyCat数据库的基础配置及使用
2026-05-18栏目: 教程
