mysql1067 aborting_mysql 在WINDOW启动下出错1067

好久没有启动MYSQL啦，今天一启动就1067，以为MY.INI配置错了，然后上网查看了下MY.INI经过对比发现没有问题。

就去查看LOG，log在这个目录下：C:/ProgramData/MySQL/MySQL Server 5.5/Data/

在MY.INI里面会有这个路径datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"；

进去里面的目录看到一个ERR结尾的文件，打开就看到了LOG；

40903 16:41:25 [Note] Plugin 'FEDERATED' is disabled.

140903 16:41:25 InnoDB: The InnoDB memory heap is disabled

140903 16:41:25 InnoDB: Mutexes and rw_locks use Windows interlocked functions

140903 16:41:25 InnoDB: Compressed tables use zlib 1.2.3

140903 16:41:25 InnoDB: Initializing buffer pool, size = 47.0M

140903 16:41:25 InnoDB: Completed initialization of buffer pool

140903 16:41:25 InnoDB: highest supported file format is Barracuda.

140903 16:41:26  InnoDB: Waiting for the background threads to start

140903 16:41:27 InnoDB: 1.1.8 started; log sequence number 389745922

140903 16:41:27 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306

140903 16:41:27 [Note]   - '0.0.0.0' resolves to '0.0.0.0';

140903 16:41:27 [Note] Server socket created on IP: '0.0.0.0'.

140903 16:41:27 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory

140903 16:41:27 [ERROR] Do you already have another mysqld server running on port: 3306 ?

140903 16:41:27 [ERROR] Aborting

一看原来端口被占用了，原来是之前在虚拟机里面装了MYSQL,会占了3306这个端口；

改一下端口就OK拉。