重装mysql时最后的Apply security setting过不去

来源：互联网发布：新浪短网址api js 编辑：程序博客网时间：2024/05/01 20:51

报错如下：
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’ (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 就好了（电脑不用重启）

0 0