Rumah  >  Artikel  >  pangkalan data  >  无法启动MySQL服务,报错1067进程意外终止的问题_MySQL

无法启动MySQL服务,报错1067进程意外终止的问题_MySQL

WBOY
WBOYasal
2016-06-01 13:39:151179semak imbas

bitsCN.com
问题表象:无法启动MySQL服务,报错1067进程意外终止的问题_MySQL我的mysql中的 my.ini文件配置:    

[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文件,查看错误原因     [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的念头,也有过砸电脑的冲动,但最后还是天不负有心人,终于找到了解决方法;     第一步:在mysql的安装目录下 basedir="D:/software_builder/mysql/的data文件夹里“D:/software_builder/mysql/data”" 下面还有一个mysql的文件夹(如图),
 无法启动MySQL服务,报错1067进程意外终止的问题_MySQL 把“mysql文件夹”拷贝到数据库的数据存放位置的data文件夹下(我的是:C:/ProgramData/MySQL/MySQL Server 5.5/data)       无法启动MySQL服务,报错1067进程意外终止的问题_MySQL 然后在服务里面启动mysql服务,结果:“I get it !”
  bitsCN.com

Kenyataan:
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Artikel sebelumnya:MYSQL中InnoDB和MyISAM的区别_MySQLArtikel seterusnya:MySQL存储引擎_MySQL