Windows XP SP3 上的 MySQL 服务器安装
我目前正在尝试在 Windows XP Professional 上安装 MySQL Server 5.5。计算机上唯一的防火墙是我已禁用的 Windows 防火墙。
我正在检查 MySQL 服务器配置,它完成了启动服务部分,但是当它尝试应用安全设置时,会显示错误,提示
“安全设置无法应用于数据库,因为连接失败并出现以下错误”。
错误编号1045 用户“root@localhost”的访问被拒绝(使用密码:NO)。
我在服务器的配置向导中设置了root帐户的密码,并且Windows防火墙被禁用。我尝试卸载MySQL服务器,删除程序文件中的MySQL服务器,重新启动并尝试重新安装,但仍然遇到相同的错误。
感谢您对这个问题的帮助。
I am currently trying to install MySQL Server 5.5 on Windows XP Professional. The only firewall on the computer is the Windows Firewall which I have disabled.
I am going through the MySQL Server configuration and it completes the starting service section but when it tries to apply security settings an error is displayed saying
'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:NO).
I have set up a password for the root account during the configuration wizard of the server and the Windows firewall is disabled. I have tried uninstalling MySQL Server, deleting the MySQL Server in program files, rebooting and trying to reinstall but I still get the same error.
Thanks for your help with this problem.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
问题算是解决了。由于某种原因,MySQL Server 5.5 会出现错误,指出防火墙正在阻止应用安全设置,即使防火墙已禁用。
但是如果你安装MySQL Server 5.1则完全没有问题。
Problem is sort of solved. For some reason MySQL Server 5.5 comes up with the error saying that a firewall is blocking the security settings settings from being applied even when the firewall is disabled.
However if you install MySQL Server 5.1 there is no problem at all.
如果您在安装过程中遇到问题并且错误为
MySQL Error Nr. 1045
,表示你已经完成了之前的MySQL安装,并且计算机系统已经读取并保存了MySQL文件。你需要做的是:
documents and settings
目录下的MySQL文件夹C:\Program Files
目录If you have problems during installation and the error is
MySQL Error Nr. 1045
, it means you've done the previous MySQL installation and that the computer system has been read and has saved MySQL files.What you need to do is:
C:\Program Files
documents and settings
您所要做的就是删除
C:\Program Files (x86)\MySQL
中的所有数据,然后从开始菜单运行mysql服务器实例配置向导并重新配置服务器您可以先删除当前实例
all you have to do is to delete all data from
C:\Program Files (x86)\MySQL
then run mysql server instance configuration wizard from Start Menu and reconfig the serveryou might remove current instance first