2010/10/11 Sabika M <sabika.makhd...@gmail.com>: > 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 <par...@mafiree.com>: > 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 <mdyk...@gmail.com>: > 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! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
