MySQL Forums
Forum List  »  Install & Repo

Re: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Posted by: N S
Date: March 23, 2007 02:50AM

You are using user "mysql" to start the daemon.

--user=mysql

Please verify the write permission/owner of the directory "/var/lib/mysql"

$ ls -l /var/lib

This directory and all files within this directory must have write permission by user 'mysql'. So you should change the owner of this dir to 'mysql'.

$ chown -R mysql mysql

For test purpose, before changing owner you can try giving write permission to the user 'mysql'.

$ chmod -R 777 mysql

Now everything should work, but changing owner is the better solution. And, don't forget to undo file mode to deafault 755 or whatever you already have.

- Navin

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.