Sentora Support Forums

Correcting the error: MySQL - ERROR 2002 (HY000) - Can't connect to local MySQL server through socket

1. Code:

   mysql -u root -p
   
   
2. Code:

   ls -lart /var/run/my*
   
   
3. Code:

   mkdir /var/run/mysqld
   
   
4. Code:

   touch /var/run/mysqld/mysqld.sock
   
   
5. Code:

   ls -lart /var/run/mysqld
   
   
6. Code:

   chown -R mysql /var/run/mysqld
   
   
7. Code:

   ls -lart /var/run/mysqld
   
   
8. Code:

   /etc/init.d/mysql restart
   
   
9. Code:

   mysql -u root -p
   
   
10. Code:

    quit