List:General Discussion« Previous MessageNext Message »
From:spacemarc Date:October 12 2010 6:39pm
Subject:Re: MySQL sock file is missing: server doesn't start
View as plain text  
2010/10/11 Sabika M <sabika.makhdoom@stripped>:
> are the permissions on that directory correct? The .sock file is created at
> start up by mysql
mysqld doesn't start because are missing /var/run/mysqld dir and
/var/run/mysqld/mysqld.sock file. Dir and file are created on mysqld
boot, i presume. It's cyclic!

2010/10/12 partha sarathy <partha@stripped>:
> once mysqld gets started then only we can see the sock file and use the same to
> connect to mysql prompt.
> check your error log... some error message will be there. make it correct
> otherwise reply the error msg.

101012 20:21:29 [Note] Plugin 'FEDERATED' is disabled.
101012 20:21:30  InnoDB: Started; log sequence number 0 44263
101012 20:21:30 [ERROR] Can't start server : Bind on unix socket: No
such file or directory
101012 20:21:30 [ERROR] Do you already have another mysqld server
running on socket: /var/run/mysqld/mysqld.sock ?
101012 20:21:30 [ERROR] Aborting
101012 20:21:30  InnoDB: Starting shutdown...
101012 20:21:31  InnoDB: Shutdown completed; log sequence number 0 44263
101012 20:21:31 [Note] mysqld: Shutdown complete


2010/10/12 Michael Dykman <mdykman@stripped>:
> More often than not, this is a file permission issue.  Does the MySQL
> user have permission to create a socket in /var/run/mysqld ?    try
>
> ls -ld /var/run/mysqld
> ls -l /var/run/mysqld
>
> and make sure everything is owned by the MySQL user.

now, i have created the /var/run/mysqld dir and change the own to mysql user:
"sudo chown mysql:mysql mysqld"
The ls -ld output is:
drwxr-xr-x 2 mysql mysql 40 2010-10-12 20:31 /var/run/mysqld

The result is still 2002 error!
Thread
MySQL sock file is missing: server doesn't startspacemarc10 Oct
  • Re: MySQL sock file is missing: server doesn't startpartha sarathy11 Oct
    • Re: MySQL sock file is missing: server doesn't startspacemarc11 Oct
      • Re: MySQL sock file is missing: server doesn't startMichael Dykman12 Oct
        • Re: MySQL sock file is missing: server doesn't startspacemarc12 Oct