The Ultimate Guide to High Availability with MariaDB

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

You are viewing an old version of this question. View the current version here.

All,

I am receiving the above and below error message out of nowhere and I don't know why. OS: Linux 16.04 LTS MariaDB server - 10.3 MariaDB client -10.3 MariaDB core - 10.3

I am using a "Galera" cluster setup, my master serve is having this issue but my slave is running fine. My slave is reading (111 "connection refused"). I assume this is because there is something wrong with MariaDB on the master and thus, it doesn't allow the connection to happen. The error below refers to a ".sock" file but the only thing I can find on the interwebs regarding that file is that it is created when the service starts and deleted when the service stops. Please let me know if I am understanding the correctly or not. I have looked everywhere and it seems that there isn't just 1 answer for my issue. This issue does persist after reboot as well. I am unable to get in to "MySQL" or even start the service, so I am unable to make any changes to anything.

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

Thanks Everyone,

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.