List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:April 13 2012 1:50pm
Subject:Re: ERROR 2002 (HY000): Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2)
View as plain text  
Hi
you have to see the reason in the mysql log file,
that is a file either in the datadir with .err extension or in the /var/log
directory.
tail the last 30 lines you will see the reason why it failed to start.

Claudio


2012/4/11 Prabhat Kumar <aim.prabhat@stripped>

> did you check permission of file /var/run/mysqld/mysqld.sock
>
> On Wed, Apr 11, 2012 at 9:48 AM, Larry Martell <larry.martell@stripped
> >wrote:
>
> > On Wed, Apr 11, 2012 at 2:51 AM, Ganesh Kumar <bugcy013@stripped>
> wrote:
> > > Hi Guys,
> > >
> > > I am using debian squeeze it's working good, I am trying to install
> > > mysql-server. mysql-server installation successfully but didn't start
> > > service
> > > root@devel:/var/run# more /etc/mysql/my.cnf |grep socket
> > > # Remember to edit /etc/mysql/debian.cnf when changing the socket
> > location.
> > > socket          = /var/run/mysqld/mysqld.sock
> > > socket          = /var/run/mysqld/mysqld.sock
> > > socket          = /var/run/mysqld/mysqld.sock
> > >
> > > root@devel:~# /etc/init.d/mysql restart
> > > Stopping MySQL database server: mysqld.
> > > Starting MySQL database server: mysqld . . . . . . . . . . . . . .
> > failed!
> > > root@devel:~# mysql -u root -p
> > > Enter password:
> > > ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> > > '/var/run/mysqld/mysqld.sock' (2)
> > > root@devel:~# cd /var/run/mysqld/
> > > root@devel:/var/run/mysqld# ls
> > > root@devel:/var/run/mysqld#
> >
> > Is selinux enabled? If so, check the logs for that.
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql
> >
> >
>
>
> --
> Best Regards,
>
> Prabhat Kumar
> MySQL DBA
>
> My Blog: http://adminlinux.blogspot.com
> My LinkedIn: http://www.linkedin.com/in/profileprabhat
>



-- 
Claudio

Thread
ERROR 2002 (HY000): Can't connect to local MySQL server throughsocket '/var/lib/mysql/mysql.sock' (2)Ganesh Kumar11 Apr
  • Re: ERROR 2002 (HY000): Can't connect to local MySQL server throughsocket '/var/lib/mysql/mysql.sock' (2)mailing@securitylabs.it11 Apr
  • Re: ERROR 2002 (HY000): Can't connect to local MySQL server throughsocket '/var/lib/mysql/mysql.sock' (2)Larry Martell11 Apr
    • Re: ERROR 2002 (HY000): Can't connect to local MySQL server throughsocket '/var/lib/mysql/mysql.sock' (2)Prabhat Kumar11 Apr
      • Re: ERROR 2002 (HY000): Can't connect to local MySQL server throughsocket '/var/lib/mysql/mysql.sock' (2)Claudio Nanni13 Apr