On Tue, 2007-11-06 at 09:32 -0600, [EMAIL PROTECTED] wrote: > i believe you need to have root create the file /var/lib/mysql/mysql.sock > and then make it readable and writable by the user that owns mysql. > > You can make that same file owner by the user that runs mysql. > > > > > -----Original Message----- > >From: Ali Nebi <[EMAIL PROTECTED]> > >Sent: Nov 6, 2007 9:24 AM > >To: mysql@lists.mysql.com > >Subject: Please help to solve a serios problem > > > >Hi, i need of help for a serios problem. > > > >We have installed mysql 5 and we are using InnoDB engine. OS is CentOS > >5, x86. > > > >Our problem is this. > >We get this message in the log: > > > > > >ERROR 2002 (HY000): Can't connect to local MySQL server through socket > >'/var/lib/mysql/mysql.sock' (111) > >ERROR 2002 (HY000): Can't connect to local MySQL server through socket > >'/var/lib/mysql/mysql.sock' (111) > > > >The problem is that mysql make recovering the database, we are > >restarting whole server and it crash again. It continue to crash. We > >tried to recover manually database, but it continue to crash. What we > >can do to solve this problem? > > > >We need to solve this problem urgently. > > > >Thanks in advanced! > > > >Regards, Ali Nebi! > > > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > >
This socket file is created automatically when i run mysql by this way: /etc/init.d/mysql start. The file has these permissions set. I think this is ok, problem is something different i think, but i don't know where. srwxrwxrwx mysql mysql system_u:object_r:mysqld_var_run_t mysql.sock -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
