Mysql配置问题

发布于 2024-07-11 06:40:19 字数 428 浏览 12 评论 0原文

我从昨晚开始就一直在努力。 起初它可以工作,但今天早上又不工作了。 我正在 vista 机器上安装 mysql 5.0 版本。 当我尝试配置时,它说: 安全设置无法应用于数据库,因为连接失败并出现以下错误: 错误编号 1045 用户“root”@“localhost”的访问被拒绝(使用密码:yes)

如果您的计算机上运行个人防火墙,则 请确保您已打开 TCP 端口 3306 进行连接。 否则没有客户端应用程序可以连接到服务器。 打开端口后,请按重试以应用安全设置。

如果您在刚刚安装 mysql 服务器后重新安装,请注意数据目录不会自动删除。 因此,仍需要上次安装时的旧密码才能连接到服务器。 在这种情况下,请选择立即跳过并从开始菜单重新运行配置向导。

我尝试禁用wirefall、用户帐户,但收到相同的错误。 谁能给我建议一下吗?

I have being trying since last night. At first it was working but this morning again its not working. I am installing mysql version 5.0 on vista machine. when i try to configure its says that:
The security settings could not be applied to the database because the connnection had failed with the following error:
Error Nr. 1045
access denied for user 'root'@'localhost'(using password:yes)

if a personal firewall is runnig on your machine plaes make sure you have opened the tcp port 3306 for connections. otherwise no client applicaion can connect to the server. after you have opened the port please press retry to apply the secirity settings.

if you are re-installing after you just installed the mysql server please not 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.

i tried disabling the wirefall, user accounts but getting the same error. can anyone suggest me something please.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

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

发布评论

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

评论(2

迎风吟唱 2024-07-18 06:40:19

我敢打赌你的密码已经被更改了。 此错误清楚地表明您正在连接到 mysql 服务器,并且您的端口已打开且工作正常。 不过,您可能连接到了错误的 mysql 服务器。 尝试重新运行安装脚本以重置密码。 如果您没有想要保留的数据,我想说最简单的方法是卸载(并删除整个 mysql 目录)并重新安装。

I bet that your password was changed. This error clearly states that you are connecting to a mysql server and that your ports are open and working fine. You may be connecting to the wrong mysql server though. Try re-running the install script to reset the password. If you have no data you would like to keep I would say the easiest way would be to uninstall (and delete the entire mysql directory) and reinstall.

眼中杀气 2024-07-18 06:40:19

我以前也遇到过这个问题。 我重新安装了 MySQL,然后运行 ​​MySQL 服务器实例配置向导,删除当前实例,然后再次运行 MySQL 服务器实例配置向导来创建一个新实例,一切正常。

I've had this issue before. I reinstalled MySQL, then ran MySQL Server Instance Config Wizard, removed the current instance, and then ran MySQL Server Instance Config Wizard again to create a new instance and everything worked fine.

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