[求助]MySQL安装正常,服务启动正常,本地连接不上?_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 3952 | 回复: 0

主题： [求助]MySQL安装正常,服务启动正常,本地连接不上?

liandong

注册用户

等级：新兵
经验：51
发帖：61
精华：0
注册：2011-11-14
状态：离线
发送短消息息给liandong

加好友发送短消息息给liandong

发消息

发表于：

2014-11-21 11:02:45 | [全部帖] [楼主帖]

楼主

以下是我的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:\>

请各位帮忙看看.先谢谢了

--转自