How to solve the problem that mysql cannot be started under linux

This article mainly tells you how to solve the problem that you can't start mysql under linux. You can check the relevant professional terms on the Internet or find some related books to supplement them. We won't dabble here, so let's go straight to the topic. I hope this article can bring you some practical help if you can't start mysql under linux.

No matter what problems you find, first check the err log.

Question 1:

Query the err log to show permission issues.

Analysis: mysql originally belongs to the mysql user, if you start under the root user, there may be problems.

Resolve:

(1) View the permissions of mysql

(2) found that there is root authority, confusion. So change it to mysql permission first

Recommended video tutorials: linux video tutorials

(3) restart and view the process

Question 2:

When you change the mysql password, you find that the mysql service is running normally, but when you log in, you are prompted: ERROR! MySQL is running but PID file could not be found

Resolve:

(1) check the running status of the database:

Service mysql status

Prompt ERROR! MySQL is running but PID file could not be found

(2) print MYSQL process

Ps aux | grep mysql

(3) KILL process:

Kill-9 pid

That is,

Kill-9 9525

Start MYSQL again:

Service mysql start

Check the running status of mysql again:

Service mysql status

Prompt for successful OK

(4) change the password

Linux can not start mysql how to solve the first to tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.