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!