程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> MySQL綜合教程 >> 無法啟動MySQL服務,報錯1067進程意外終止的問題

無法啟動MySQL服務,報錯1067進程意外終止的問題

編輯:MySQL綜合教程


問題表象: 我的mysql中的 my.ini文件配置:   www.2cto.com  

[csharp] #Path to installation directory. All paths are usually resolved relative to this.   basedir="D:/software_builder/mysql/"     #Path to the database root   datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/"   我在 datadir的路徑下找到.err文件,查看錯誤原因   www.2cto.com     [html] 121022 15:21:06 [Note] Plugin 'FEDERATED' is disabled.   D:\software_builder\mysql\bin\mysqld: Table 'mysql.plugin' doesn't exist   121022 15:21:06 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.   121022 15:21:06 InnoDB: The InnoDB memory heap is disabled   121022 15:21:06 InnoDB: Mutexes and rw_locks use Windows interlocked functions   121022 15:21:06 InnoDB: Compressed tables use zlib 1.2.3   121022 15:21:06 InnoDB: Initializing buffer pool, size = 500.0M   121022 15:21:06 InnoDB: Completed initialization of buffer pool   121022 15:21:06  InnoDB: Log file .\ib_logfile0 did not exist: new to be created   InnoDB: Setting log file .\ib_logfile0 size to 100 MB   InnoDB: Database physically writes the file full: wait...   InnoDB: Progress in MB: 100   121022 15:21:07  InnoDB: Log file .\ib_logfile1 did not exist: new to be created   InnoDB: Setting log file .\ib_logfile1 size to 100 MB   InnoDB: Database physically writes the file full: wait...   InnoDB: Progress in MB: 100   121022 15:21:10 InnoDB: highest supported file format is Barracuda.   InnoDB: The log sequence number in ibdata files does not match   InnoDB: the log sequence number in the ib_logfiles!   121022 15:21:10  InnoDB: Database was not shut down normally!   InnoDB: Starting crash recovery.   InnoDB: Reading tablespace information from the .ibd files...   InnoDB: Restoring possible half-written data pages from the doublewrite   InnoDB: buffer...   121022 15:21:10  InnoDB: Waiting for the background threads to start   121022 15:21:11 InnoDB: 1.1.8 started; log sequence number 3700748   121022 15:21:11 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist     嘗試過無數種網絡搜索的解決方法,有過重裝mysql的念頭,也有過砸電腦的沖動,但最後還是天不負有心人,終於找到了解決方法;   www.2cto.com     第一步:在mysql的安裝目錄下 basedir="D:/software_builder/mysql/的data文件夾裡“D:\software_builder\mysql\data”" 下面還有一個mysql的文件夾(如圖),
    把“mysql文件夾”拷貝到數據庫的數據存放位置的data文件夾下(我的是:C:\ProgramData\MySQL\MySQL Server 5.5\data)     www.2cto.com       然後在服務裡面啟動mysql服務,結果:“I get it !”
 

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