以下是我的MySQL安装运行的环境:
系统:Windows 2003 Standard R2 SP1
MySQL版本5.1.33
防火墙:ZoneAlarm 5.5.094.000
防毒杀毒:NOD 2.70.39
MySQL安装一切正常,服务正常启动,但是,当我在命令行: mysql -uroot -p 提示输入 Enter Password: 因为密码为空,就直接按回车键,没反应.等了很久后就电脑就不响应,只好Ctrl+C将控制台关闭.电脑才可正常运行.啥原因?
关闭防火墙,杀毒软件,MySQL还是连接无响应.
防火墙设置IP地址 端口运行,MySQL还是连接无响应.
使用telnet 127.0.0.1 3306 是正常的:
以下是telnet信息:
5.1.33-community-log +=2%^.g<ToU9\C{c_2z
失去了跟主机的连接。
以下是MySQL日志文件信息:
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld, Version: 5.1.33-community-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld, Version: 5.1.33-community-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld, Version: 5.1.33-community-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld, Version: 5.1.33-community-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld, Version: 5.1.33-community-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld, Version: 5.1.33-community-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld, Version: 5.1.33-community-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld, Version: 5.1.33-community-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld, Version: 5.1.33-community-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
另外.本机上已经安装的软件:
JDK1.6
MS SQL Server 2000 服务启动的
IIS6.0
ASP.NET 2.0.50727
以下是netstat -an信息:
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 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:1433 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING
TCP 0.0.0.0:4200 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8081 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1029 127.0.0.1:1030 ESTABLISHED
TCP 127.0.0.1:1030 127.0.0.1:1029 ESTABLISHED
TCP 127.0.0.1:1080 127.0.0.1:1081 ESTABLISHED
TCP 127.0.0.1:1081 127.0.0.1:1080 ESTABLISHED
TCP 127.0.0.1:1084 127.0.0.1:1085 ESTABLISHED
TCP 127.0.0.1:1085 127.0.0.1:1084 ESTABLISHED
TCP 127.0.0.1:5152 0.0.0.0:0 LISTENING
TCP 127.0.0.1:31000 127.0.0.1:32000 ESTABLISHED
TCP 127.0.0.1:32000 0.0.0.0:0 LISTENING
TCP 127.0.0.1:32000 127.0.0.1:31000 ESTABLISHED
TCP 192.168.0.134:1058 60.28.216.15:80 CLOSE_WAIT
TCP 192.168.0.134:1067 119.145.130.7:80 CLOSE_WAIT
TCP 192.168.0.134:2221 220.181.37.210:80 ESTABLISHED
TCP 192.168.0.134:2240 220.181.37.210:80 ESTABLISHED
TCP 192.168.0.134:2329 61.152.236.140:80 ESTABLISHED
TCP 192.168.0.134:2338 220.181.37.210:80 ESTABLISHED
TCP 192.168.0.134:2339 220.181.37.210:80 ESTABLISHED
TCP 192.168.0.134:2343 124.238.254.44:80 ESTABLISHED
TCP 192.168.0.134:2400 64.4.34.198:1863 ESTABLISHED
TCP 192.168.0.134:2880 203.208.33.101:80 LAST_ACK
TCP 192.168.0.134:2894 220.181.37.210:80 TIME_WAIT
TCP 192.168.0.134:2895 220.181.37.210:80 TIME_WAIT
TCP 192.168.0.134:2896 203.208.33.100:80 ESTABLISHED
TCP 192.168.0.134:2897 59.151.24.179:80 ESTABLISHED
TCP 192.168.0.134:2898 123.235.43.124:80 ESTABLISHED
TCP 192.168.0.134:2900 203.208.33.101:80 ESTABLISHED
TCP 192.168.0.134:2901 203.208.33.101:80 ESTABLISHED
TCP 192.168.0.134:2902 64.233.189.164:80 CLOSE_WAIT
TCP 192.168.0.134:2903 64.233.189.154:80 CLOSE_WAIT
TCP 192.168.0.134:2904 59.151.24.147:80 ESTABLISHED
TCP 192.168.0.134:2905 64.233.189.156:80 CLOSE_WAIT
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1027 *:*
UDP 0.0.0.0:1041 *:*
UDP 0.0.0.0:1059 *:*
UDP 0.0.0.0:1108 *:*
UDP 0.0.0.0:1418 *:*
UDP 0.0.0.0:1419 *:*
UDP 0.0.0.0:1434 *:*
UDP 0.0.0.0:1459 *:*
UDP 0.0.0.0:1468 *:*
UDP 0.0.0.0:1469 *:*
UDP 0.0.0.0:1582 *:*
UDP 0.0.0.0:1583 *:*
UDP 0.0.0.0:1584 *:*
UDP 0.0.0.0:1585 *:*
UDP 0.0.0.0:1586 *:*
UDP 0.0.0.0:1587 *:*
UDP 0.0.0.0:1588 *:*
UDP 0.0.0.0:1589 *:*
UDP 0.0.0.0:1590 *:*
UDP 0.0.0.0:1593 *:*
UDP 0.0.0.0:1594 *:*
UDP 0.0.0.0:1615 *:*
UDP 0.0.0.0:1900 *:*
UDP 0.0.0.0:2103 *:*
UDP 0.0.0.0:4000 *:*
UDP 0.0.0.0:4001 *:*
UDP 0.0.0.0:4002 *:*
UDP 0.0.0.0:4500 *:*
UDP 0.0.0.0:13734 *:*
UDP 127.0.0.1:1033 *:*
UDP 127.0.0.1:1039 *:*
UDP 127.0.0.1:1191 *:*
UDP 127.0.0.1:1591 *:*
UDP 127.0.0.1:2395 *:*
UDP 192.168.0.134:9 *:*
C:\>
请各位帮忙看看.先谢谢了
--转自