好久没有启动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拉。