MySql安装问题

最新推荐文章于 2022-11-13 19:09:16 发布

iteye_11390

最新推荐文章于 2022-11-13 19:09:16 发布

阅读量137

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： Error No.1045 MySql

本文链接：https://blog.youkuaiyun.com/iteye_11390/article/details/82211036

数据库专栏收录该内容

1 篇文章

订阅专栏

本文提供了解决MySQL安装过程中出现的ErrorNr.1045访问被拒绝错误的方法。该错误通常发生在使用默认root用户登录时。解决方案包括确保个人防火墙已打开TCP端口3306，并在重新安装MySQL前删除旧的数据目录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql安装（Error Nr.1045）错误解决办法

Tags:

MYSQL

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 uou 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\

转载自：http://www.88m.org/info.asp?id=303