MYSQL64位的一些安装与启动方法_you can check this by doing 'telnet localhost 3306-优快云博客

本文链接：https://blog.youkuaiyun.com/tianqiruanjian/article/details/18945029

测试环境：Win7 64位，硬件信息不做考虑范围。

下载地址：http://xiazai.zol.com.cn/detail/4/33431.shtml

安装过后执行以下命令检测是否可以正常连接，以下是错误信息。说明连接不到

C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqladmin.exe status
mysqladmin.exe: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

随即执行系统命令检测TCP端口状态。发现3306端口没有监听。导致连接不上。

C:\Windows\system32>netstat -an
活动连接
协议本地地址外部地址状态
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:443 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:902 0.0.0.0:0 LISTENING
TCP 0.0.0.0:912 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1025 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1027 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2113 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2869 0.0.0.0:0 LISTENING
TCP 0.0.0.0:5678 0.0.0.0:0 LISTENING
TCP 0.0.0.0:12473 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1118 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1118 127.0.0.1:1145 ESTABLISHED
TCP 127.0.0.1:1145 127.0.0.1:1118 ESTABLISHED
TCP 127.0.0.1:8307 0.0.0.0:0 LISTENING
TCP 169.254.172.91:139 0.0.0.0:0 LISTENING
TCP 169.254.246.15:139 0.0.0.0:0 LISTENING
TCP 192.168.90.3:139 0.0.0.0:0 LISTENING
TCP 192.168.90.3:1043 74.125.128.125:5222 ESTABLISHED
TCP 192.168.90.3:1101 64.4.44.95:1863 ESTABLISHED
TCP 192.168.90.3:1546 117.79.157.251:80 ESTABLISHED
TCP 192.168.90.3:1641 123.150.173.168:20014 ESTABLISHED
TCP 192.168.90.3:1734 118.67.120.124:80 ESTABLISHED
TCP 192.168.90.3:1740 118.67.120.115:80 ESTABLISHED
TCP 192.168.90.3:1742 118.67.120.93:80 ESTABLISHED
TCP 192.168.90.3:1743 118.67.121.174:80 ESTABLISHED
TCP 192.168.90.3:1808 74.125.128.102:443 ESTABLISHED
TCP 192.168.90.3:1864 117.79.157.201:80 ESTABLISHED
TCP 192.168.90.3:1867 220.181.112.152:80 LAST_ACK
TCP [::]:135 [::]:0 LISTENING
TCP [::]:443 [::]:0 LISTENING
TCP [::]:445 [::]:0 LISTENING
TCP [::]:1025 [::]:0 LISTENING
TCP [::]:1026 [::]:0 LISTENING
TCP [::]:1027 [::]:0 LISTENING
TCP [::]:2869 [::]:0 LISTENING
TCP [::1]:8307 [::]:0 LISTENING
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:4000 *:*
UDP 0.0.0.0:4500 *:*
UDP 0.0.0.0:5355 *:*
UDP 0.0.0.0:5678 *:*
UDP 0.0.0.0:10275 *:*
UDP 0.0.0.0:15005 *:*
UDP 0.0.0.0:19889 *:*
UDP 0.0.0.0:49191 *:*
UDP 0.0.0.0:52080 *:*
UDP 0.0.0.0:52385 *:*
UDP 0.0.0.0:56307 *:*
UDP 0.0.0.0:56311 *:*
UDP 0.0.0.0:57110 *:*
UDP 0.0.0.0:59467 *:*
UDP 0.0.0.0:59468 *:*
UDP 0.0.0.0:60121 *:*
UDP 0.0.0.0:64941 *:*
UDP 127.0.0.1:1900 *:*
UDP 127.0.0.1:51473 *:*
UDP 127.0.0.1:54005 *:*
UDP 127.0.0.1:61600 *:*
UDP 127.0.0.1:63473 *:*
UDP 127.0.0.1:64303 *:*
UDP 169.254.172.91:137 *:*
UDP 169.254.172.91:138 *:*
UDP 169.254.172.91:1900 *:*
UDP 169.254.172.91:63471 *:*
UDP 169.254.246.15:137 *:*
UDP 169.254.246.15:138 *:*
UDP 169.254.246.15:1900 *:*
UDP 169.254.246.15:63472 *:*
UDP 192.168.90.3:9 *:*
UDP 192.168.90.3:137 *:*
UDP 192.168.90.3:138 *:*
UDP 192.168.90.3:1900 *:*
UDP 192.168.90.3:63470 *:*
UDP [::]:500 *:*
UDP [::]:4500 *:*
UDP [::]:5355 *:*
UDP [::1]:1900 *:*
UDP [::1]:63469 *:*
UDP [fe80::550f:7a2e:b994:f60f%13]:546 *:*
UDP [fe80::550f:7a2e:b994:f60f%13]:1900 *:*
UDP [fe80::550f:7a2e:b994:f60f%13]:63468 *:*
UDP [fe80::e0ba:2382:8e5c:ac5b%12]:546 *:*
UDP [fe80::e0ba:2382:8e5c:ac5b%12]:1900 *:*
UDP [fe80::e0ba:2382:8e5c:ac5b%12]:63467 *:*
UDP [fe80::e98b:5277:7f39:c352%11]:546 *:*
UDP [fe80::e98b:5277:7f39:c352%11]:1900 *:*
UDP [fe80::e98b:5277:7f39:c352%11]:63466 *:*