Windows XP SP3 上的 MySQL 服务器安装

发布于 2024-10-09 07:59:04 字数 364 浏览 7 评论 0原文

我目前正在尝试在 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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

请帮我爱他 2024-10-16 07:59:04

问题算是解决了。由于某种原因,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.

疯狂的代价 2024-10-16 07:59:04

如果您在安装过程中遇到问题并且错误为MySQL Error Nr. 1045,表示你已经完成了之前的MySQL安装,并且计算机系统已经读取并保存了MySQL文件。

你需要做的是:

  1. 通过控制面板卸载MySQL
  2. 下的MySQL文件夹删除documents and settings目录下的MySQL文件夹
  3. 删除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:

  1. Uninstall MySQL through the control panel
  2. Delete the MySQL folder in C:\Program Files
  3. Delete the MySQL folder in the directory documents and settings
悟红尘 2024-10-16 07:59:04

您所要做的就是删除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 server
you might remove current instance first

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文