The attention! Attention! Attention! The following operation, please read and then decide on your own whether to adopt this recommendation!
.
.
, then the text begins
drummed up mysql again recently, met a haven’t seen before.
the problem are as follows:
baidu for a long time, found that the articles are the same, the solutions are almost the same, but in here I have no use.
so looked over the wall of the outside world, finally found a useful solution. font> font>
mysql at initialization time, directory will detect whether there is font> if not, mysql creates it font> if there is, and the data are there in this directory, mysql complains, initialization and termination of font> if none of the above problems, it may be that the folder permissions problems font> solution (here in my operation path, for example, specific please refer to our own path) :
2, through the above we can see :datadir path and socket path. .
chmod -R 777 /var/lib/mysql
3, next delete /var/lib/mysql folder contents :
rm -rf /var/lib/mysql/*
4, restart service :
service mysqld restart
at this point, if you look at the status, you can see mysql is up :
Read More:
- MySQL uses net start MySQL startup prompt (failed to start, the service did not report any error)
- After installing MySQL again under Linux, the solution of ‘MySQL module failed to start’ appears
- MySQL failed to start prompt: job failed to start
- MySQL error set: failed to start mysql.service : Unit mysql.service is masked.
- [Solved] Tomcat Failed to Start Error: Server Tomcat v8.5 Server at localhost failed to start
- Error: (serious: a child container failed during start) (server component failed to start so Tomcat is unable)
- Server Tomcat v8.0 Server at localhost failed to start.
- Ubuntu failed to start sshd with an error: failed to start OpenBSD secure shell server
- It can’t connect to local MySQL server through socket ‘/ tmp/ mysql.sock ‘(2) “;
- Server Tomcat v7.0 server at localhost failed to start
- The MySQL service suddenly hangs up with the error message can’t connect to MySQL server on ‘localhost’ (10061)
- mysql problem solving: mysqladmin: connect to server at’localhost’ failed
- The server just without updating PID file and can’t connect to local MySQL server through socket are solved
- MYSQL login error: mysqladmin: connect to server at’localhost’ failed
- Solve net start mysql, start MySQL service, prompt system error 5. Access denied.
- MySQL installation failed: dpkg: error processing package MySQL server (- – configure): dependency problem
- When MySQL is running, the server suddenly goes down, which causes Mysql to be unable to restart
- MySQL: if the remote connection using navicatip fails, prompt “is not allowed to connect to this MySQL server”
- An error was reported during MySQL 6.0 installation: start service failed
- Server operation and maintenance 1-failed to start LSB