Mysql startup anomaly, deployed on Centos7 mysql5.7 version cleared some mysql - bin. 000118 similar these logs, lead to mysql cannot be started, which eldest brother help, thanked the

CodePudding user response:

Recommend to install

CodePudding user response:

Regardless of the lost data, will the mysql - bin. The index content to empty, will start the database, which is the database to reset the log file

Or look at the http://www.xker.com/page/e2012/1122/121973.html

CodePudding user response:

Permissions problem!
Chown mysql. Mysql/home/mysql
Chmod -r 777 mysql mysql/home/mysql
Then start the mysql service

CodePudding user response:

You said that the method had tried all useless

CodePudding user response:

Should be accidentally deleted some files
If not already created a database and data file, a new error
Modifying my. CNF file directory:
Datadir=/var/lib/mysql to change directory

Restart the mysql, change passwords, initialization,

CodePudding user response:

3/f said very clearly, permission problems