无法连接到“本地主机"上的MySQL服务器(10061) [英] Can't connect to MySQL server on 'localhost' (10061)

问题描述

我最近在Windows 2003上安装了MySQL 5，并尝试配置实例.一切正常，直到我进入应用安全设置"，这时才出现上述错误(Can't connect to MySQL server on 'localhost' (10061)).

I recently installed MySQL 5 on Windows 2003 and tried configuring an instance. Everything worked fine until I got to "Applying Security settings", at which point it gave me the above error (Can't connect to MySQL server on 'localhost' (10061)).

我的防火墙中确实存在"MySQL Server"的端口3306异常.

I do have a port 3306 exception in my firewall for 'MySQL Server'.

推荐答案

您可能必须向用户授予表上的"localhost"特权.请参见'GRANT'语法文档.这是一个示例(来自C语言).

You'll probably have to grant 'localhost' privileges to on the table to the user. See the 'GRANT' syntax documentation. Here's an example (from some C source).

在％s上授予所有特权.*由'％s'标识为'％s'@'localhost'"

"GRANT ALL PRIVILEGES ON %s.* TO '%s'@'localhost' IDENTIFIED BY '%s'";

这是MySQL最常见的访问问题.

That's the most common access problem with MySQL.

除此之外，您可能会检查为创建实例定义的用户是否具有完全特权，否则该用户无法授予特权.

Other than that, you might check that the user you have defined to create your instance has full privileges, else the user cannot grant privileges.

另外，请确保mysql服务已启动.

Also, make sure the mysql service is started.

确保您没有打开第三方防火墙或Internet安全服务.

Make sure you don't have a third party firewall or Internet security service turned on.

除此之外，MySQL论坛还专门介绍了几页: http://forums.mysql.com/read.php?11 ，9293,9609#msg-9609

Beyond that, there's several pages of the MySQL forum devoted to this: http://forums.mysql.com/read.php?11,9293,9609#msg-9609

尝试阅读.

这篇关于无法连接到“本地主机"上的MySQL服务器(10061)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！