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

Question

I tried restarting the Mysql server but its not working for me. I am sure the server is running and the permissions on the folder /var/lib/mysql/ are correct (777).

When i tried to open the file mysql.sock, its giving me an error saying the file may be corrupt.

Please help me to log on to the mysql server.

Answer 1

First: Make sure that the owner of /var/lib/mysql and its files and subdirectories is mysql user of mysql group

to do that run the following command:

chown mysql:mysql -R /var/lib/mysql/*

Second: change write permissions to rwxr-xr-x (755) for mysql directory, and all its files and subdirectories, by running the following command:

chmod 755 -R /var/lib/mysql/*

now start mysql service

service mysql start

Answer 2

i had same problem and solved with:

mysql_install_db --user=mysql

reference: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db/

Answer 3

For me, stopping docker in the background was the solution. Nothing else worked, and nothing pointer to docker except when running

lsof -i TCP:3306

and then trying to

kill <process_id> 

the error from docker popped up so I knew Docker was having some background mysql listeners.

Answer 4

It's a bit late, but maybe the reason is not enough RAM. Add a swapfile. See https://forums.docker.com/t/var-lib-mysql-mysql-sock-is-not-created-sometimes/142851/5

RAM problem permanently solved by adding a swapfile. It remains strange that

• the creation of the socket should have been prevented by the lack of memory and

• that the error also occurs when setting up a swap file, but has no effect in this case.

Answer 5

Just do it, it worked to me...

mysql.server start

[mysql -u "username" -p "password"]