Win 7 mysql安裝錯誤（the security settings could not be applied to the database （error 1045 MySQL）

標籤：apply security setting

    安裝MYSQL最後一步“Apply security setting”出現如下錯誤：

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：刪除MYSQL安裝目錄（我的是C:\Program Files），刪除整個MYSQL檔案夾。

    3：重新安裝MYSQL。

    注意：（本人也沒有調查到具體原因）

    如果之前安裝過MYSQL，並建立過資料庫，可忽略此錯誤，實際上MYSQL安裝是成功的，開啟NAVICAT（我用的是NAVICAT管理的MYSQL資料庫），可看到之前建立的連結和資料庫還在。

本文出自 “javaruler” 部落格，請務必保留此出處http://tengjs.blog.51cto.com/5641106/1565694

Win 7 mysql安裝錯誤（the security settings could not be applied to the database （error 1045 MySQL）