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拉。
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
