【已解决】mysql：ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) (2024)

场景

在连接mysql数据库时，提示报错：

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061)

解决方案

1.在命令行窗口，输入：

See Also
Connecticut Sun draft French prospect Leïla Lacan with 10th pick - The NextWDFW approves seven days of coastal razor clam digs starting April 23; additional tentative digs planned for May 6-12Parkland vs. Emmaus baseball, 04.16.24Episode 75: Voices from the Field: National Public Safety Telecommunicators Week 2024

netstat -ano

在cmd命令里输入“netstat -ano”查看端口使用情况。这时你应该找不到3306这个端口号：

C:\Windows\System32>netstat -ano活动连接 协议 本地地址 外部地址 状态 PID TCP 0.0.0.0:135 0.0.0.0:0 LISTENING 1776 TCP 0.0.0.0:445 0.0.0.0:0 LISTENING 4 TCP 0.0.0.0:5040 0.0.0.0:0 LISTENING 8016 TCP 0.0.0.0:7680 0.0.0.0:0 LISTENING 844 TCP 0.0.0.0:49664 0.0.0.0:0 LISTENING 1420 TCP 0.0.0.0:49665 0.0.0.0:0 LISTENING 1276 TCP 0.0.0.0:49666 0.0.0.0:0 LISTENING 2064 TCP 0.0.0.0:49667 0.0.0.0:0 LISTENING 2900 TCP 0.0.0.0:49668 0.0.0.0:0 LISTENING 4144 TCP 0.0.0.0:49669 0.0.0.0:0 LISTENING 1360 TCP 127.0.0.1:63342 0.0.0.0:0 LISTENING 12312 TCP 192.168.1.5:139 0.0.0.0:0 LISTENING 4 TCP 192.168.1.5:49677 20.198.162.78:443 ESTABLISHED 4640 TCP 192.168.1.5:49714 20.198.162.78:443 ESTABLISHED 5920 TCP 192.168.1.5:49846 142.251.8.188:5228 ESTABLISHED 11012 TCP 192.168.1.5:50513 120.92.107.7:443 ESTABLISHED 11012 TCP 192.168.1.5:50514 120.92.107.6:443 ESTABLISHED 11012 TCP 192.168.1.5:50661 119.3.217.249:443 ESTABLISHED 11012 TCP 192.168.1.5:50670 121.36.68.44:443 ESTABLISHED 11012 TCP 192.168.1.5:50679 58.254.149.230:443 TIME_WAIT 0 TCP 192.168.1.5:50680 58.254.137.230:443 TIME_WAIT 0 TCP 192.168.1.5:50681 58.254.149.230:443 TIME_WAIT 0 TCP 192.168.1.5:50688 58.254.137.230:443 TIME_WAIT 0 TCP 192.168.1.5:50695 58.254.149.165:443 TIME_WAIT 0 TCP 192.168.1.5:50702 58.254.149.165:443 TIME_WAIT 0 TCP 192.168.1.5:50706 58.254.137.165:443 TIME_WAIT 0 TCP 192.168.1.5:50707 58.254.149.165:443 TIME_WAIT 0 TCP 192.168.1.5:50711 58.254.137.230:443 TIME_WAIT 0 TCP 192.168.1.5:50733 58.254.137.230:443 TIME_WAIT 0 TCP 192.168.1.5:50735 58.254.149.228:443 TIME_WAIT 0 TCP 192.168.1.5:50739 58.254.137.230:443 TIME_WAIT 0 TCP 192.168.1.5:50879 118.89.204.198:443 ESTABLISHED 11012 TCP 192.168.1.5:50889 172.217.160.106:443 FIN_WAIT_1 11012 TCP 192.168.1.5:50923 172.217.160.106:443 FIN_WAIT_1 11012 TCP 192.168.1.5:50974 172.217.160.106:443 FIN_WAIT_1 11012 TCP 192.168.1.5:51007 157.255.135.87:443 ESTABLISHED 11012 TCP 192.168.1.5:51040 172.217.160.106:443 FIN_WAIT_1 11012 TCP 192.168.1.5:51041 202.89.233.101:443 ESTABLISHED 11012 TCP 192.168.1.5:51045 202.89.233.101:443 ESTABLISHED 11012 TCP 192.168.1.5:51046 202.89.233.101:443 ESTABLISHED 11012 TCP 192.168.1.5:51047 202.89.233.101:443 ESTABLISHED 11012 TCP 192.168.1.5:51048 202.89.233.101:443 ESTABLISHED 11012 TCP 192.168.1.5:51049 27.36.125.193:443 ESTABLISHED 11012 TCP 192.168.1.5:51050 27.36.125.193:443 ESTABLISHED 11012 TCP 192.168.1.5:51052 123.129.227.53:443 ESTABLISHED 11012 TCP 192.168.1.5:51053 123.129.227.53:443 ESTABLISHED 11012 TCP 192.168.1.5:51054 157.255.138.47:443 ESTABLISHED 11012 TCP 192.168.1.5:51056 157.255.138.43:443 ESTABLISHED 11012 TCP 192.168.1.5:51060 121.36.68.44:443 ESTABLISHED 11012 TCP 192.168.1.5:51061 120.46.216.189:443 ESTABLISHED 11012 TCP 192.168.1.5:51062 61.241.151.249:443 ESTABLISHED 11012 TCP 192.168.1.5:51063 157.148.69.74:443 ESTABLISHED 11012 TCP 192.168.1.5:51064 110.242.69.113:443 CLOSE_WAIT 11012 TCP 192.168.1.5:51068 124.71.236.98:443 ESTABLISHED 11012 TCP 192.168.1.5:51070 58.254.137.230:443 ESTABLISHED 11012 TCP 192.168.1.5:51071 58.254.149.230:443 ESTABLISHED 11012 TCP 192.168.1.5:51079 58.254.149.228:443 ESTABLISHED 11012 TCP 192.168.1.5:51080 58.254.149.166:443 ESTABLISHED 11012 TCP 192.168.1.5:51081 182.161.73.146:443 LAST_ACK 11012 TCP 192.168.1.5:51083 185.84.60.23:443 ESTABLISHED 11012 TCP 192.168.1.5:51084 58.254.149.230:443 ESTABLISHED 11012 TCP 192.168.1.5:51087 171.39.5.38:443 ESTABLISHED 11012 TCP 192.168.1.5:51088 185.84.60.23:443 ESTABLISHED 11012 TCP 192.168.1.5:51090 58.254.149.230:443 ESTABLISHED 11012 TCP 192.168.1.5:51092 123.249.126.38:8086 ESTABLISHED 11012 TCP 192.168.1.5:51093 123.249.99.208:443 ESTABLISHED 11012 TCP 192.168.1.5:51095 123.249.99.208:443 ESTABLISHED 11012 TCP 192.168.1.5:51096 123.249.126.38:8086 ESTABLISHED 11012 TCP 192.168.1.5:51097 58.254.149.230:443 ESTABLISHED 11012 TCP 192.168.1.5:51102 157.255.135.87:443 ESTABLISHED 11012 TCP 192.168.1.5:51104 182.161.73.146:443 LAST_ACK 11012 TCP 192.168.1.5:51105 142.251.42.234:443 SYN_SENT 11012 TCP 192.168.1.5:51106 142.251.43.10:443 SYN_SENT 11012 TCP 192.168.1.5:51107 172.217.160.106:443 SYN_SENT 11012 TCP 192.168.1.5:51108 172.217.163.42:443 SYN_SENT 11012 TCP 192.168.1.5:51109 172.217.160.106:443 SYN_SENT 11012 TCP 192.168.1.5:51110 142.251.42.234:443 SYN_SENT 11012 TCP 192.168.1.5:51111 172.217.160.106:443 SYN_SENT 11012 TCP 192.168.1.5:51112 142.251.42.234:443 SYN_SENT 11012 TCP 192.168.1.5:51113 172.217.160.106:443 SYN_SENT 11012 TCP 192.168.1.5:51114 58.254.149.230:443 ESTABLISHED 11012 TCP 192.168.1.5:51115 172.217.160.106:443 SYN_SENT 11012 TCP 192.168.1.5:51116 58.254.149.228:443 ESTABLISHED 11012 TCP 192.168.1.5:51119 108.160.165.8:443 SYN_SENT 11012 TCP 192.168.1.5:51120 108.160.165.8:443 SYN_SENT 11012 TCP 192.168.1.5:51121 58.254.149.230:443 ESTABLISHED 11012 TCP 192.168.1.5:51122 142.251.42.234:443 SYN_SENT 11012 TCP 192.168.1.5:51123 172.217.163.42:443 SYN_SENT 11012 TCP 192.168.1.5:51124 142.251.42.234:443 SYN_SENT 11012 TCP 192.168.1.5:51125 172.217.163.42:443 SYN_SENT 11012 TCP 192.168.1.5:51126 111.206.209.249:443 ESTABLISHED 11012 TCP 192.168.1.5:51127 172.217.160.106:443 SYN_SENT 11012 TCP 192.168.1.5:51128 172.217.160.106:443 SYN_SENT 11012 TCP 192.168.1.5:51129 142.251.43.10:443 SYN_SENT 11012 TCP 192.168.1.5:51130 172.217.160.106:443 SYN_SENT 11012 TCP 192.168.1.5:51131 172.217.163.42:443 SYN_SENT 11012 TCP [::]:135 [::]:0 LISTENING 1776 TCP [::]:445 [::]:0 LISTENING 4 TCP [::]:7680 [::]:0 LISTENING 844 TCP [::]:49664 [::]:0 LISTENING 1420 TCP [::]:49665 [::]:0 LISTENING 1276 TCP [::]:49666 [::]:0 LISTENING 2064 TCP [::]:49667 [::]:0 LISTENING 2900 TCP [::]:49668 [::]:0 LISTENING 4144 TCP [::]:49669 [::]:0 LISTENING 1360 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:49768 [2603:1046:c03:e::2]:443 ESTABLISHED 9016 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:50520 [2408:8756:92ff:300:1::eb]:443 ESTABLISHED 11012 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:50553 [2620:1ec:46::254]:443 CLOSE_WAIT 9016 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:50555 [2606:2800:147:120f:30c:1ba0:fc6:265a]:443 CLOSE_WAIT 9016 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:50563 [2606:2800:147:120f:30c:1ba0:fc6:265a]:443 CLOSE_WAIT 9016 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:50874 [2408:8752:100:10:142::4b]:443 ESTABLISHED 11012 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:50883 [2408:8752:100:10:142::4b]:443 ESTABLISHED 11012 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:51055 [2408:8756:aff:400::3afe:9631]:443 ESTABLISHED 11012 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:51059 [2408:8756:92ff:300:1::eb]:443 ESTABLISHED 11012 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:51067 [2408:8756:92ff:300:1::eb]:443 ESTABLISHED 11012 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:51072 [2407:c080:1400:57:f85b:6894:e943:69b1]:443 ESTABLISHED 11012 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:51073 [2407:c080:1400:57:f85b:6894:e943:69b1]:443 ESTABLISHED 11012 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:51075 [2407:c080:1400:57:f85b:6894:e943:69b1]:443 ESTABLISHED 11012 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:51117 [2a03:2880:f11f:83:face:b00c:0:25de]:443 SYN_SENT 11012 TCP [2408:8459:810:ec87:ed53:6cef:a31b:ea7]:51118 [2a03:2880:f11f:83:face:b00c:0:25de]:443 SYN_SENT 11012 UDP 0.0.0.0:123 *:* 14120 UDP 0.0.0.0:5050 *:* 8016 UDP 0.0.0.0:5353 *:* 2752 UDP 0.0.0.0:5353 *:* 14328 UDP 0.0.0.0:5353 *:* 14328 UDP 0.0.0.0:5355 *:* 2752 UDP 127.0.0.1:1900 *:* 11160 UDP 127.0.0.1:49664 127.0.0.1:49664 4564 UDP 127.0.0.1:63519 *:* 11160 UDP 192.168.1.5:137 *:* 4 UDP 192.168.1.5:138 *:* 4 UDP 192.168.1.5:1900 *:* 11160 UDP 192.168.1.5:63518 *:* 11160 UDP [::]:123 *:* 14120 UDP [::]:5353 *:* 2752 UDP [::]:5353 *:* 14328 UDP [::]:5355 *:* 2752 UDP [::1]:1900 *:* 11160 UDP [::1]:63517 *:* 11160 UDP [fe80::5f18:5043:9e4b:e988%17]:1900 *:* 11160 UDP [fe80::5f18:5043:9e4b:e988%17]:63516 *:* 11160C:\Windows\System32>

第1步：在桌面底部搜索：计算机管理，打开。

【已解决】mysql：ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) (1)

第2步：右侧找到服务---mysqlxx（我的是mysql80）---右击：重启

【已解决】mysql：ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) (2)
【已解决】mysql：ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) (3)

3.如果还是报错，则检查mysql配置文件my.ini：

【已解决】mysql：ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) (4)
【已解决】mysql：ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) (5)

配置文件完整如下：

[mysqld]#设置3306端口号port=3306#设置MySQL的安装目录basedir=D:\\mysql\\mysql-8.0.33-winx64#设置MySQL数据库的数据存放目录datadir=D:\\mysql\\mysql-8.0.33-winx64\\data20231013#运行最大连接数max_connections=200#运行连接失败的次数。这也是为了防止有人从该主机试图攻击数据库系统max_connect_errors=10#服务端使用的字符集默认为utf-8character-set-server=utf8[mysql]#客户端使用的字符集默认为utf8default-character-set=utf8[client]#客户端默认端口号为3306port=3306

重新启动服务，在窗口登录：

【已解决】mysql：ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) (6)

登录成功

【已解决】mysql：ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061) (2024)
Top Articles
Jesse Marsch: Leeds got worse after I left – the owners told me they sacked me too soon
5 big reasons to pay attention to what’s happening at the border right now | CNN
Fallout 4's 'next gen' update is over 14 gigs, breaks modded saves, and doesn't seem to change much at all
Skyrim : ce mod hilarant permet aux utilisateurs de Twich d'incarner n'importe quel PNJ
Latest Posts
Afghanistan vs Pakistan 2nd ODI Highlights: Imam Ul Haq, Babar Azam Shine As Pakistan Beat Afghanistan In Thriller | Cricket News
Group Of American Leaders Representing The Colonies
Article information

Author: Velia Krajcik

Last Updated:

Views: 6348

Rating: 4.3 / 5 (54 voted)

Reviews: 85% of readers found this page helpful

Author information

Name: Velia Krajcik

Birthday: 1996-07-27

Address: 520 Balistreri Mount, South Armand, OR 60528

Phone: +466880739437

Job: Future Retail Associate

Hobby: Polo, Scouting, Worldbuilding, Cosplaying, Photography, Rowing, Nordic skating

Introduction: My name is Velia Krajcik, I am a handsome, clean, lucky, gleaming, magnificent, proud, glorious person who loves writing and wants to share my knowledge and understanding with you.