程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> 更多編程語言 >> 編程綜合問答 >> mysql-MySQL服務啟動不了,日志如下,求大神

mysql-MySQL服務啟動不了,日志如下,求大神

編輯:編程綜合問答
MySQL服務啟動不了,日志如下,求大神

150204 17:08:10 InnoDB: The InnoDB memory heap is disabled
150204 17:08:10 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150204 17:08:10 InnoDB: Compressed tables use zlib 1.2.3
150204 17:08:10 InnoDB: Initializing buffer pool, size = 150204 17:09:19 [Note] Plugin 'FEDERATED' is disabled.
150204 17:09:19 InnoDB: The InnoDB memory heap is disabled
150204 17:09:19 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150204 17:09:19 InnoDB: Compressed tables use zlib 1.2.3
150204 17:09:19 InnoDB: Initializing buffer pool, size = 150204 17:11:44 [Note] Plugin 'FEDERATED' is disabled.
150204 17:11:44 InnoDB: The InnoDB memory heap is disabled
150204 17:11:44 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150204 17:11:44 InnoDB: Compressed tables use zlib 1.2.3
150204 17:11:44 InnoDB: Initializing buffer pool, size = 150204 17:20:45 [Note] Plugin 'FEDERATED' is disabled.
150204 17:20:45 InnoDB: The InnoDB memory heap is disabled
150204 17:20:45 InnoDB: Mutexes and rw_locks use Windows interlocked functions
150204 17:20:45 InnoDB: Compressed tables use zlib 1.2.3
150204 17:20:45 InnoDB: Initializing buffer pool, size =

最佳回答:


今天在啟動myql時候突然報了一個這個錯誤,感覺非常的奇怪,想起我唯一做了的改變就是把系統臨時文件夾改了到了我用內存虛擬出來的硬盤分區裡面,估計和這個是有關系的,
121113 10:52:30 [Note] Plugin ‘FEDERATED’ is disabled.
121113 10:52:30 InnoDB: The InnoDB memory heap is disabled
121113 10:52:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121113 10:52:30 InnoDB: Compressed tables use zlib 1.2.3
處理辦法:1:打開my.ini文件
2:添加一句 tmpdir = e:/mysqltem 你的臨時文件夾 重啟mysql 搞定了
No tags for this post.

安裝完MySQL後啟動時失敗,查看應用程序日志,提示

Plugin 'FEDERATED' is disabled

再看配置文件my.ini

裡邊把 datadir 都指向C盤去了

datadir="C:\Program Files\MySQL\MySQL Server 5.5\data\"

但我的MySQL是安裝在D盤的,於是修改之:
datadir="D:/MySQL/MySQL Server 5.5/Data/"
然後再把C盤指向的MySQL整個文件夾刪除,重啟服務,OK

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved