Docker chown cannot dereference var/lib/mysql mysql sock No such file or directory

Check domysqld.sock and mysqld.pid exist or not. If not, inside the docker terminal, run these commands :

Then, restart mysql service :

Still, if your mysql can’t connect to mysql. Run this method and restart the service of mysql (maybe you also need to restart the container if still can’t connect to mysql) :

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.

Abdul Manaf

9,34914 gold badges68 silver badges83 bronze badges

asked Jan 20, 2012 at 4:33

2

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:

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

now start mysql service

answered Jan 20, 2012 at 5:13

Abdul ManafAbdul Manaf

9,34914 gold badges68 silver badges83 bronze badges

2

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

and then trying to

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

answered Mar 30, 2021 at 8:09

Just do it, it worked to me...

mysql.server start

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

answered May 31, 2021 at 11:04

Not the answer you're looking for? Browse other questions tagged mysql mysql-5 or ask your own question.

I can not start MariaDB because there is no mysqld.sock file in var/run/mysqld/ folder. I have uninstalled and reinstalled.

I have run mysql_install_db, it was apparently successful. When I ran mysqld_safe it had problems. Mysql-secure_installation hangs with an error no such file in mysqld.sock /var/run/mysqld/. Searching for it came up empty, there was no such file anywhere.

I am having trouble with generating a bug report.

My question is how do find, download, or make the missing file. I have searched mysql and googled without any success.

My OS is Ubuntu 11.04

Answer

Try doing:

cd /etc/init.d Go to where mysqld is, and try: ./mysqld start

Then do mysql -uroot and see if you can login.

Also, it would help if you tell us how you installed MariaDB. Thanks!

• ↑ Starting and Stopping MariaDB ↑

Comments

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.

Starting yesterday, I'm getting this error when connecting to mysql:

I haven't touched my setup for ~1 month so I don't believe its driven by any changes I've attempted to make to the setup. When I try to restart mysql service with

I get this error:

And if I try:

I just get:

I think its a permissions issue based off what I've read on other server fault threads about the same error but I'm still stumped because I should have permissions to execute files in that directory:

Update: logs below. Looks like a memory issue but I don't know how to address:

UPDATE: Found the answer here which was setting up a swap file. The full details I followed on how to do this can be found here: http://www.prowebdev.us/2012/05/amazon-ec2-linux-micro-swap-space.html