windows平台输入mysqld命令，没有返回(好像书上说没有返回是正常的)，就直接把窗口关掉了。
之后使用服务开启数据库报错，
C:\Documents and Settings\18450>net start mysql55
MySQL55 服务正在启动 ....
MySQL55 服务无法启动。
系统出错。
发生系统错误 1067。
进程意外终止。
查看错误日志信息
121019 10:19:40 [Note] Plugin 'FEDERATED' is disabled.
121019 10:19:40 InnoDB: The InnoDB memory heap is disabled
121019 10:19:40 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121019 10:19:40 InnoDB: Compressed tables use zlib 1.2.3
121019 10:19:40 InnoDB: Initializing buffer pool, size = 42.0M
121019 10:19:40 InnoDB: Completed initialization of buffer pool
121019 10:19:40 InnoDB: highest supported file format is Barracuda.
121019 10:19:45 InnoDB: Waiting for the background threads to start
121019 10:19:46 InnoDB: 1.1.8 started; log sequence number 8798687
121019 10:19:46 [Note]Serverhostname
(bind-address): '0.0.0.0'; port: 3306
121019 10:19:46 [Note] - '0.0.0.0' resolves to '0.0.0.0';
121019 10:19:46 [Note] Server socket created on IP: '0.0.0.0'.
121019 10:19:46 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
121019 10:19:46 [ERROR] Do you already have another mysqld server running on port: 3306 ?
121019 10:19:46 [ERROR] Aborting
121019 10:19:46 InnoDB: Starting shutdown...
121019 10:19:47 InnoDB: Shutdown completed; log sequence number 8798687
121019 10:19:47 [Note] C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete
错误日志说端口被占用，
1。
C:\Documents and Settings\18450>netstat -ano
Active Connections
Proto Local Address Foreign Address State PID
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING 1496
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING 4
TCP 0.0.0.0:1000 0.0.0.0:0 LISTENING 3344
TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING 4892
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING 1772
2。杀掉进程
C:\Documents and Settings\18450>ntsd -c q -p 4892
3。
重新启动
C:\Documents and Settings\18450>net start mysql55
MySQL55 服务正在启动 ..
MySQL55 服务已经启动成功。
分享到：
2013-01-17 17:41
浏览 174
评论