Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have a MySQL server running on Amazon EC2 in a VPC instance. I had to change the instance type of it to handle load and when I brought it back up, the socket didn't exist anymore. The file /var/run/mysqld/mysqld.sock doesn't exist and nor does the directory.

I have no idea where it went, but it is just gone. So is there a way to fix that? If so how? The server is running Ubuntu 10.04.

share|improve this question

1 Answer 1

up vote 4 down vote accepted

Check that your /etc/mysql/my.cnf file agrees that the file should be /var/run/mysqld

socket  = /var/run/mysqld/mysqld.sock

and if it does then

sudo mkdir -p /var/run/mysqld
sudo service mysql restart

but I suspect your problem lies elsewhere as the mysql start script will create the directory if it doesn't exist. Is there any relevant message in your mysql logs ?

share|improve this answer
    
Well that seemed to fix everything. I think the problem was that I was using mysqld and /etc/init.d/mysql start to start the server, but I never tried the service method. That was the only one that would create the directory and socket. –  Dave Long Aug 25 '11 at 22:37
    
bizarrely, i get this every time i enter my server. and every time i must apply this solution to fix it. would be great if there were some permanent fix. –  Hermann Ingjaldsson Jul 30 at 10:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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