Mysql error 1067

Because the log files have been accumulated for a long time (under the data Directory), delete them! Mysql-bin.000001 ...... the original deletion of the mysql-bin.000278 are left with the last number of logs, this time too thorough ~~ All deleted! Run netstartmysql: mysql1067 error! Check the host name. err file (lenovo

Because it has been used for a long time to accumulate a lot of log files (under the \ data directory), delete it! Mysql-bin.000001 ...... the original deletion of the mysql-bin.000278 are left with the last number of logs, this time too thorough ~~ All deleted! Run net start mysql: mysql 1067 error! Check the host name. err file (lenovo

Zookeeper

Because it has been used for a long time to accumulate a lot of log files (under the \ data directory), delete it!

Mysql-bin.000001

......

Mysql-bin.000278

The log with the last number is deleted. This time it is too thorough ~~ All deleted!

Execute net start mysql:

Mysql 1067 error!

View, host name. err file (lenovo-7c8f808d.err ):

[Plain]View plaincopyprint?

1. 130416 9:59:23 InnoDB: Started; log sequence number 0 43655
2. MySQL: File '. \ mysql-bin.000278' not found (Errcode: 2)
3. 130416 9:59:23 [ERROR] Failed to open log (file '. \ mysql-bin.000278', errno 2)
4. 130416 9:59:23 [ERROR] cocould not open log file
5. 130416 9:59:23 [ERROR] Can't init tc log
6. 130416 9:59:23 [ERROR] Aborting
8. 130416 9:59:23 InnoDB: Starting shutdown...
9. 130416 9:59:24 InnoDB: Shutdown completed; log sequence number 0 43655
10. 130416 9:59:24 [Note] MySQL: Shutdown complete

130416  9:59:23  InnoDB: Started; log sequence number 0 43655MySQL: File '.\mysql-bin.000278' not found (Errcode: 2)130416  9:59:23 [ERROR] Failed to open log (file '.\mysql-bin.000278', errno 2)130416  9:59:23 [ERROR] Could not open log file130416  9:59:23 [ERROR] Can't init tc log130416  9:59:23 [ERROR] Aborting130416  9:59:23  InnoDB: Starting shutdown...130416  9:59:24  InnoDB: Shutdown completed; log sequence number 0 43655130416  9:59:24 [Note] MySQL: Shutdown complete

Tell us that the mysql-bin.000278 file is not found!

We can't find a new log file:

Open the my. ini file

Change the text in the red box to mysql-B.

Save the my. ini file.

Restart the mysql service:

Mysql is started normally!