打开mysql3306库报错_[ERROR] Do you already have another mysqld server running on port: 3306

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] Server hostname (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 服务已经启动成功。