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.
mysql at initialization time, directory will detect whether there is if not, mysql creates it if there is, and the data are there in this directory, mysql complains, initialization and termination of if none of the above problems, it may be that the folder permissions problems 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