Can't connect to local MySQL server through socket '/tmp/mysql.sock'

[Metin2Place 30]

Hello, I changed my server on 64 bit and once in 1-2 weeks I get an error and I must make a restore from a 32bit backup to mysql. Why do I get this and how can I resolve it?

Error: mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[HellBoy 199]

Your Mysql gets fucked due low space try keep the logs clean.

How to fix:

Reinstall Mysql = 25% chance to solve it and that pointing highter.

Reinstall OS

To avoid this kind of issues create a config file using:

^{# ee  /usr/local/etc/my.cnf}

then add this: 

_{# The MySQL server configuration
[mysqld]
socket          = /tmp/mysql.sock}

_{#Expire binary logs after 5 days:
expire_logs_days = 5}

_{#Max size logs delete
max_binlog_size = 100M}

 

 

[Hik 108]

Write:

ee /etc/rc.conf and checks to see whether mysql_enable="YES", If you do not enter this and reboot.

Now, if at the start you see the written Starting mysql are almost at the end.

If not, repeat the step above.

Enter your login data and type:

mysqld_safe start

then

rehash

 

 

 

[Metin2Place 30]

Thanks, I will try that. Using "df -h" I see that I have 5.4GB (49%) free. I have space.