Unable to start MySQL service, error 1067 unexpected Process Termination

Source: Internet
Author: User


Problem description: my. ini file configuration in my mysql: 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 Server 5.5/Data/"I found it in the datadir path. in the err file, view the error cause 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.0 M 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 fi Le 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 found the solution; www.2cto.com Step 1: Under the mysql installation directory basedir = "D:/software_builder/mysql/data folder" D: \ software_builder \ mysql \ data ", there is 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) www.2cto.com and then start the mysql service in the service. The result is: "I get it!"
 

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.