Something like:
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
Ok this was tough enough to find. :P
Three simple things.
the number inside parenthesis indicates the error number we want to think about firstly. The number two means that mysql daemon cannot find that file. So, to solve this, try to
1 |
$ touch /var/run/mysqld/mysqld.sock |
and then try to run
1 |
$ start mysql |
.
If you get another error like
1 |
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'(111) |
this means the mysql deamon crashes because it cannot write to the file.
2. Just write
1 |
$ df -h |
and check if your filesystem (most cases) or the Hard drive you use for mysql is … full! Simply delete some files and run
1 |
$ start mysql |
again.
Don’t believe it? Just check it!
Thnx for reading,
Specktator
-
Engineers Get Shit Done Funny T-Shirt16.00 € – 21.50 €
-
Being a Systems Administrator is like … T-Shirt16.00 € – 21.50 €
-
SysAdmin Mug14.00 € – 19.50 €