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

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.