blocks|key|1416242|text|尝试使用localhost而不是127.0.0.1来连接或在connection-config中进行连接。在Debian+Squeeze服务器上为我工作|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1416243|entityMap^0|4|9|G|9|U|H|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

Try <code>localhost</code> instead of <code>127.0.0.1</code> to connect or in your <code>connection-config</code>. Worked for me on a Debian Squeeze Server

blocks|key|1416532|text|当您在连接数据库之前忘记启动数据库时，就会发生这种情况：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1416533|mysql.server+start|code-block|syntax|javascript|1416534|然后|1416535|mysql+-u+root+-p+-h+127.0.0.1|1416536|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

This happens when you forget to start the database before connecting to it:

<pre><code>mysql.server start
</code></pre>

then

<pre><code>mysql -u root -p -h 127.0.0.1
</code></pre>

blocks|key|1416287|text|在我的例子中(远程连接)帮助关闭了服务器上的防火墙。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1416288|service+iptables+stop|code-block|syntax|javascript|1416289|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In my case (remote connnection) helped turning off firewall on server.

<pre><code>service iptables stop
</code></pre>

blocks|key|1201391|text|出现此问题的原因可能是您的MySQL服务器未安装且未运行。要以admin身份启动命令提示符，然后输入命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1201392|"C:\Program+Files+(x86)\MySQL\MySQL+Server+5.1\bin\mysqld"+--install|code-block|syntax|javascript|1201393|如果您收到“服务成功安装”消息，则需要启动MySQL服务。为此:转到服务窗口(任务管理器、->服务、->开放服务)，搜索MySQL并从顶部导航栏启动它。然后，如果尝试打开mysql.exe，它将会起作用。|1201394|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This problem may occur because your MySQL server is not installed and running.
To do that start command prompt as admin and enter command:

<pre><code>"C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld" --install
</code></pre>

If you get "service successfully installed" message then you need to start the MySQL service. To do that: go to Services window
(Task Manager -> Services -> Open Services) 
Search for MySQL and Start it from the top navigation bar.
Then if try to open mysql.exe it will work.

blocks|key|1416703|text|如果您在这里带着相同的错误消息，并且您使用Docker+-尝试使用数据库服务的名称作为主机。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1416704|services:
++app:
++++blablabla
++db:
++++blablabla|code-block|syntax|javascript|1416705|我是说，而不是：|1416706|127.0.0.1+or+localhost|1416707|使用：|1416708|db|1416709|entityMap|0|LINK|mutability|MUTABLE|url|https://en.wikipedia.org/wiki/Docker_%2528software%2529^0|L|6|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|13|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|14|8|@]|9|@]|C|$G|H]]|$1|M|3|N|5|6|7|15|8|@]|9|@]|C|$]]|$1|O|3|P|5|F|7|16|8|@]|9|@]|C|$G|H]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]]]

If you are here with the same error message and you use <a href="https://en.wikipedia.org/wiki/Docker_%28software%29" rel="nofollow noreferrer">Docker</a> - try to use the name of the database service as a host.
<pre><code>services:
 app:
 blablabla
 db:
 blablabla
</code></pre>
I mean, instead of:
<pre class="lang-none prettyprint-override"><code>127.0.0.1 or localhost
</code></pre>
use:
<pre><code>db
</code></pre>

blocks|key|1201066|text|您需要在mysql配置文件(my.ini或my.cnf)中将绑定地址参数更改为127.0.0.1，或者使用在那里定义的参数。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1201067|如果这不起作用，您应该检查mysql服务是否正在运行。|1201068|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You need to change the bind-address parameter to 127.0.0.1 in the mysql config file (my.ini or my.cnf) or use the one that is defined there.

If that doesn't work you should check that the mysql service is actually running.

blocks|key|1416237|text|如果您在非默认端口上运行，您可以尝试使用--port=<port+num>，前提是--skip-networking为not+enabled.|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1416238|entityMap^0|K|H|15|H|1N|C|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|O|8|@]|D|@]|E|$]]]|G|$]]

Incase you are running on a non-default port, you may try using <code>--port=&lt;port num&gt;</code> 
provided <code>--skip-networking</code> is <code>not enabled.</code>

blocks|key|1201284|text|我也面临着同样的问题。下面的帮助我解决了这个问题->控制面板->管理工具-->服务在这里面你肯定会看到MySQL服务:右击并说启动(强制启动)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1201285|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I was also facing the same issue.
The following helped me fix the problem
go to control panel-> Administrative tools-->services inside this you will most certainly see the MySQL servce: right click and say start(force start).

blocks|key|1201332|text|我就是有个问题...在Win7和wamp服务器中运行...在reading+this之后|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1201333|已发现防病毒防火墙导致了此问题。|1201334|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sitepoint.com/forums/showthread.php?547573-ERROR-2003-%2528HY000%2529^0|U|C|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

I just have this problem.... running in Win7 and wamp server ... after <a href="http://www.sitepoint.com/forums/showthread.php?547573-ERROR-2003-%28HY000%29" rel="nofollow">reading this</a> 

Found that Antivirus Firewall has caused the problem.

blocks|key|1201493|text|尝试不要关闭iptables并打开端口3306。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1201494|sudo+iptables+-A+INPUT+-i+eth0+-p+tcp+-m+tcp+--dport+3306+-j+ACCEPT|code-block|syntax|javascript|1201495|如果使用的是ufw，则为sudo+ufw+allow+3306。|offset|length|style|CODE|1201496|check：netstat+-lnp+%7C+grep+mysql你应该会得到这样的东西：|1201497|cp++++++++0++++++0+127.0.0.1:3306++++++++++0.0.0.0:*+++++++++++++++LISTEN++++++2048/mysqld+++++++++
tcp6+++++++0++++++0+:::33060++++++++++++++++:::*++++++++++++++++++++LISTEN++++++2048/mysqld+++++++++
unix++2++++++[+ACC+]+++++STREAM+++++LISTENING+++++514961+++2048/mysqld++++++++++/var/run/mysqld/mysqld.sock
unix++2++++++[+ACC+]+++++STREAM+++++LISTENING+++++514987+++2048/mysqld++++++++++/var/run/mysqld/mysqlx.sock|1201498|如果您有null，则删除cnf文件中port+=+3306之前的#。|1201499|entityMap^0|0|0|C|J|0|6|P|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@$I|X|J|Y|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|Z|8|@$I|10|J|11|K|L]]|9|@]|A|$]]|$1|O|3|P|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|T|$]]

Try dont shut down iptables and open port 3306.

<pre><code>sudo iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT
</code></pre>

or <code>sudo ufw allow 3306</code> if you use ufw.

check: <code>netstat -lnp | grep mysql</code> you should get sth like that:

<pre><code>cp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 2048/mysqld 
tcp6 0 0 :::33060 :::* LISTEN 2048/mysqld 
unix 2 [ ACC ] STREAM LISTENING 514961 2048/mysqld /var/run/mysqld/mysqld.sock
unix 2 [ ACC ] STREAM LISTENING 514987 2048/mysqld /var/run/mysqld/mysqlx.sock
</code></pre>

if you have null then delete # before port = 3306 in cnf file.

blocks|key|1416640|text|如果您已经尝试了以上所有方法，但仍然不起作用。检查防火墙。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1416641|我试图从windows机器连接到安装在装有CentOs7的VirtualBox机器上的MySql服务器5.7.32。我已经尝试了所有方法，但都不起作用，即使我可以ping通我无法连接到MySql服务器的机器。|1416642|在CentOs7上，用于检查防火墙的命令为：|1416643|步骤1:检查防火墙服务的状态：|1416644|systemctl+status+firewallid.service|code-block|syntax|javascript|1416645|步骤2:关闭防火墙服务|1416646|systemctl+stop+firewallid.service|1416647|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|U|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

If you have tried all of the above and it still did not work. Check firewall.
I was trying to connect from a windows machine to a MySql Server 5.7.32 installed on a VirtualBox machine with CentOs7. I have tried everything and it was not working, even though i could ping the machine i couldn't connect to the MySql Server.
On CentOs7 the commands to check the firewall are:
Step 1: Check the status of your firewall service:
<pre><code>systemctl status firewallid.service
</code></pre>
Step 2: Disable the firewall service
<pre><code>systemctl stop firewallid.service
</code></pre>

blocks|key|1416475|text|我在重新安装时更改了安装目录，它起作用了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1416476|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I changed the installation directory on re-install, and it worked.

blocks|key|1201242|text|我只需重新启动mysql服务器，问题就解决了，在windows+net中停止MySQL，然后net+start+MySQl+ubuntu+linux+sudo+service启动mysql。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1201243|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

i just restart my mysql server and the problem solved
in windows net stop MySQL then net start MySQl
ubuntu linux sudo service start mysql

I use the following command:

<pre><code>mysql -u root -h 127.0.0.1 -p
</code></pre>

and the error message is :

<pre><code>ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
</code></pre>

Who can help me to fix it?

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)

我使用以下命令：mysql -u root -h 127.0.0.1 -p错误消息是：ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)谁能帮我解决这个问题？

问错误2003 (HY000)：无法连接到'127.0.0.1‘上的MySQL服务器(111)
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问错误2003 (HY000)：无法连接到'127.0.0.1‘上的MySQL服务器(111)EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问错误2003 (HY000)：无法连接到'127.0.0.1‘上的MySQL服务器(111)
EN