mysql 在WINDOW啟動下出錯1067

標籤：windows   memory   tables   mysql   

    好久沒有啟動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拉。

mysql 在WINDOW啟動下出錯1067