Can't connect to local MySQL server through socket '/tmp/mysql.sock'

[notnotBigE]

I am a bit of a newb with Linux and have been researching this for hours, so please fogive me if this has been answered already. I can get MySQL to start only when I am logged in as root. I want to be able to have it start at bootup. When I try to start it at boot up or if I am logged in as a user other than root, I get the error "Can't connect to local MySQL server through socket '/tmp/mysql.sock'". Can anyone help me on this? Much appreciated!

Regards,

E

 

[abombss]

It sounds like the permissions on your temp directory are incorrect. You need to set the sticky bit. Try running this command.

chmod -R 777 /tmp

abombss

 

[abombss]

I am sorry... I forget to set the sticky bit. Try this command instead.

chmod -R 1777 /tmp

This will allow anyone to read / write / execute a file in the temp directory. A more conservative setting would be.

chmod -R 1755 /tmp

Cheers,

abombss