MySQL "another MySQL daemon already running with the same UNIX socket" processing and thinking

Source: Internet
Author: User
Tags mysql login

Woke up this morning found MySQL login is not on, service mysqld restart first package correct again reported failure, reported the error is another MySQL daemon already running with the same UNIX Socke T. too upset, the small in the early morning to give me a plug, see how to clean up your uncle.

Just do this: RM var/lib/mysql/mysql.sock

Then serve: Service mysqld start

I'll go! Not even! The top!

Start over: shutdown-h now

After coming in: Mv/var/lib/mysql/mysql.sock/var/lib/mysql/mysql.sock.bak;

Then service mysqld start

Ok! finally can have a peace of mind to eat breakfast.

Think about it, last night on the use of MySQL with the usual operation is the same, usually all right ah, how can appear this problem, later Niang a bit, the original last night virtual machine directly on the power outage, MySQL process no normal retreat. So it's a tragedy! There's a solution online: RM Mysql.sock, but I didn't do it the first time.

Although not a big problem, but early in the very disturbing!

MySQL "another MySQL daemon already running with the same UNIX socket" processing and thinking

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.