Win7 system prompt: The local failed to start the MySQL service, reported error: 1067, the process of unexpected termination of the workaround.
The local computer failed to start the MySQL service error 1067 process terminated unexpectedly.
This is typically a My.ini file configuration error.
1. First find this file: The default installation path under Win7
C:\ProgramData\MySQL\MySQL Server 5.6\my.ini
Open this file found: Default-storage-engine=innodb
Change the value of Default-storage-engine to: MYISAM.
2. But there are still problems: because the databases you created before are still there (if not deleted),
Default path:
C:\ProgramData\MySQL\MySQL Server 5.6\data
This problem may come up at this point:
The Efault-storage-engine set for the first time is not the same as the value of the second setting, which may cause
(1) Found unable to select Add transaction support Data Engine InnoDB
(2) May say does not support InnoDB etc.
Workaround:
Delete: C:\ProgramData\MySQL\MySQL Server 5.6\data Directory
Ib_logfile0
Ib_logfile1
Ibdata1
Restart the service and make the achievement OK again
3, if still not, check
C:\ProgramData\MySQL\MySQL Server 5.6\data The error log in this directory (extension I is. err), which displays the following:
2015-06-24 08:53:30 7736 [Note] Plugin ' federated ' is disabled.
2015-06-24 08:53:30 1724 InnoDB:Warning:Using innodb_additional_mem_pool_size is DEPRECATED. This option is removed in future releases, together with the option Innodb_use_sys_malloc and with the InnoDB ' s intern Al memory allocator.
2015-06-24 08:53:30 7736 [Note] innodb:using Atomics to ref count buffer pool pages
2015-06-24 08:53:30 7736 [Note] innodb:the InnoDB memory heap is disabled
2015-06-24 08:53:30 7736 [Note] innodb:mutexes and rw_locks use Windows interlocked functions
2015-06-24 08:53:30 7736 [Note] innodb:memory barrier is not used
2015-06-24 08:53:30 7736 [Note] innodb:compressed tables use zlib 1.2.3
2015-06-24 08:53:30 7736 [Note] innodb:not using CPU CRC32 instructions
2015-06-24 08:53:30 1724 InnoDB:Error:unable to create temporary file; Errno:2
2015-06-24 08:53:30 7736 [ERROR] Plugin ' InnoDB ' init function returned ERROR.
2015-06-24 08:53:30 7736 [ERROR] Plugin ' InnoDB ' registration as a STORAGE ENGINE failed.
2015-06-24 08:53:30 7736 [ERROR] unknown/unsupported storage Engine:innodb
2015-06-24 08:53:30 7736 [ERROR] Aborting
One of the core tips is this sentence, temporary files cannot be created:
2015-06-24 08:53:30 1724 InnoDB:Error:unable to create temporary file; Errno:2
So check out My.ini
In [mysqld] section, add:
#自己指定的临时文件目录
Tmpdir=d:\mysqltemp
D:\mysqltemp This directory can be specified by itself
Workarounds for MySQL service not starting in Win7 system