Solved: Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’
June 28, 2015 / by Marco / Categories : TechnologyMy VPS server experienced an issue with mySQL server and thought I’d better document how to resolve it in case it happens again.
The symptoms
- An Error message saying unable to connect to the database comes up when trying to access websites using WordPress
- Manually starting the mysqld came back with “Failed”- using the command
service mysqld restart
- Rebooting didn’t fix the problem
- When trying to run “mysql” an error message came back with
The solution
For some reason this worked for me – it may not work for you. All you have to do is run the database in recovery mode so follow these instructions:
SSH into your VPS server
Edit the my.cnf file in the folder /etc and add the following line:
innodb_force_recovery = 1
Then save the file
Restart mysqld by using the following command:
service mysqld restart
It should now work. If the server started with OK then it worked.
Go back and disable the innodb recovery by either removing the line or just adding a # at the front.
Hopefully this has fixed your issue.
More information about innodb force recovery: Click here
OTHER ARTICLES YOU MAY LIKE
POWERFUL REFERRAL PROGRAM TOOL
Businesses of all sizes are constantly seeking new and innovative ways to grow their customer base and increase brand awareness. With the rise of social media and the reliance on word-of-mouth marketing, referral programs have become an essential tool for companies looking to expand their reach. However, managing a successful referral program can be a […]
read moreCYBER SECURITY PLATFORM FOR YOUR BUSINESS
Cyber security has become a top priority for individuals and organizations alike. With the ever-evolving threat of cyber attacks, it is imperative to have a strong and reliable security platform in place to protect sensitive information and data. That’s where Bleach Cyber comes in. As a leading cyber security platform, Bleach Cyber is dedicated to […]
read more