MySQL Start error solution: Failed to open log (file './mysql-bin.000901 ', errno 2)

Ps-ef|grep MySQL
There is no MySQL process in the found, so reboot.

Service Mysqld Start Error
Viewing the error log
Tail-100/usr/local/mysql/var/iz11yohng9az.err (host name. Err)

180223 15:31:51 Mysqld_safe starting mysqld daemon with databases from/usr/local/mysql/var180223 15:31:51 innodb:the Inn ODB memory Heap is disabled180223 15:31:51 innodb:mutexes and rw_locks use GCC atomic builtins180223 15:31:51 innodb:com Pressed tables use zlib 1.2.3180223 15:31:51 innodb:initializing buffer pool, size = 16.0m180223 15:31:51 innodb:complet Ed initialization of buffer pool180223 15:31:51 innodb:highest supported file format is barracuda.180223 15:31:51 InnoDB : Waiting for the background threads to start180223 15:31:52 innodb:5.5.42 started; Log sequence number 106443096/usr/local/mysql/bin/mysqld:file './mysql-bin.000901 ' not Found (errcode:2) 180223 15:31:52 [ERROR] Failed to open log (file './mysql-bin.000901 ', errno 2) 180223 15:31:52 [ERROR] Could not open log file180 223 15:31:52 [ERROR] Can ' t init tc log180223 15:31:52 [ERROR] Aborting180223 15:31:52 innodb:starting shutdown ... 180223 15:31:53 Innodb:shutdown completed; Log sequence Number 106443096180223 15:31:53 [Note]/usr/local/mysql/bin/mysqld:shutdown complete180223 15:31:53 mysqld_safe mysqld from PID File/usr/lo Cal/mysql/var/iz11yohng9az.pid Ended

You can see the error message that appears in the error log: Failed to open log (file './mysql-bin.000901 ', errno 2)

So try the solution as follows:

cd /usr/local/mysql/var/cp mysql-bin.index mysql-bin.index.bak（备份）vi mysql-bin.index删除其中的mysql-bin.000901

Then reboot, MySQL starts successfully

MySQL Start error solution: Failed to open log (file './mysql-bin.000901 ', errno 2)