Unable to start MySQL service, error 1067 unexpected process termination problem _ MySQL
Source: Internet
Author: User
The MySQL service cannot be started. an error is reported, indicating that the 1067 process was terminated unexpectedly. bitsCN.com
Problem Description: my. ini file configuration in my mysql:
[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 Server 5.5/Data/"I found it in the datadir path. err file, view the error cause [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.0 M 121022 15:21:06 InnoDB: Completed initialization of buffer pool 121022 1 5: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. 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 has tried countless network search solutions, had the idea of re-installing mysql, and had the impulse to hit the computer, but in the end it was still a day to live, finally, the solution is found. Step 1: in the data folder basedir = "D:/software_builder/mysql/under the mysql installation directory," D: /software_builder/mysql/data "" There is also a mysql folder (),
Copy the "mysql folder" to the data folder where the database data is stored (my files are: C:/ProgramData/MySQL Server 5.5/data) start the mysql service in the service. The result is: "I get it!"
BitsCN.com
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.