Home » Home Server » Error 2002 (HY000) – Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Error 2002 (HY000) – Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

Recently, out of the blue, I started receiving the following error message and mysql would not start properly:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I searched for solutions and resorted to reinstalling mysql, which worked for me. If you have similar problems, then try the following.
First, backup your databases:

sudo su
cp -r /var/lib/mysql /BackupLocation

Then remove mysql-server.

sudo apt-get remove --purge mysql-server-5.1

Reinstall mysql-server.

sudo apt-get install mysql-server-5.1

Normally doing the above should not remove your databases and their privileges. But we backup the databases just to be cautious.
Thats it. My mysql server started working again and my blog is back up now.

UPDATE 1: The error reappeared after reboot. I later found that this happened because of a full / drive (excessive logging). Upon clearing all the logs the error disappeared.

UPDATE 2: Due to requests on how I cleared the log, I am adding further details. In my case the root partition where the /var/log folder was located was about 10 Gb. This partition filled up causing the MySQL error. First thing I did was to elevate myself to root:

/var/log$ sudo su

Once you have administrative privileges, navigate to /var/log and find out which logs are huge. You can do this using the following command:

/var/log# ls -alh

In my case the following log files where huge: mail.err, mail.info, messages, syslog, etc. You can reset these logs using the following commands:

/var/log# >mail.err
/var/log# >mail.info
/var/log# >messages
/var/log# >syslog

You can do the same this for any logs that are full. You can also delete archived logs using the following command:

/var/log# rm *.gz

NOTE: Server logs may contain important information. You will lose the logs if you reset them.

In my case this freed up space and MySQL started working.Therefore, as an initial fix, I wrote a bash script to reset my logs and added it to my daily cron job list. So all my logs were reset every morning.

I wrote the following script to cleanup my /var/log files that were filling up too quickly.

rm /var/log/*.gz ;
rm /var/log/*.1 ;
rm /var/log/*.2 ;
rm /var/log/*.3 ;
>/var/log/mail.err ;
>/var/log/mail.info ;
>/var/log/mail.warn ;
>/var/log/daemon.log ;
>/var/log/kern.log ;
>/var/log/mail.log ;
>/var/log/messages ;
>/var/log/syslog ;
>/var/log/ufw.log

Save the script to some name (example: logcleanup.sh) and run it

sudo ./logcleanup.sh

However, the actual problem of logs filling up still remained. To find out how I solved the problem, follow this thread: http://ubuntuforums.org/showthread.php?t=1501194

Additionally, you could use logrotate to rotate your logs. Played with /etc/logrotate.conf and files in /etc/logrotate.d/ to modify logrotation.

We Are Hiring: Familiar with Media Streaming, HTPC, Home Server, Smart Home, and Home Automation topics? Write about it and earn money. No writing experience needed. APPLY HERE.

Get 20% OFF with IPVanish VPN:

♦   Hide your browsing and streaming activity: No logs and no tracking
♦   Access geo-restricted content from anywhere
♦   Encrypt and anonymize: Kodi, Plex, Downloads, Personal Info
♦   Windows, Mac, Linux, Android, iOS, Router, and more.
♦   Money back guarantee - Sign Up Now

About the author

Anand

Anand is a self-learned computer enthusiast, a part-time blogger, and a Food Scientist by career. He has been blogging since 2010 on Linux, Ubuntu, Home/Media/File Servers, Smart Home Automation, and related HOW-TOs on htpcbeginner.com and smarthomebeginner.com.

Archives

Join the other 110,000 followers

Don’t Miss Out!