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!"