Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)

Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)

Are you connecting to localhost or 127.0.0.1 ? I noticed that when you connect to localhost the socket connector is used, but when you connect to 127.0.0.1 the TCP/IP connector is used. You could try using 127.0.0.1 if the socket connector is not enabled/working.

Ensure that your mysql service is running

service mysqld start

Then, try the one of the following following:

(if you have not set password for mysql)

mysql -u root

if you have set password already

mysql -u root -p

Cant connect to local MySQL server through socket /var/lib/mysql/mysql.sock (2)

If your file my.cnf (usually in the etc folder) is correctly configured with

socket=/var/lib/mysql/mysql.sock

you can check if mysql is running with the following command:

mysqladmin -u root -p status

try changing your permission to mysql folder. If you are working locally, you can try:

sudo chmod -R 777 /var/lib/mysql/

that solved it for me