The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

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

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,

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.