Try to look under the directory /var/lib/mysql/
You will need to be root or mysql user. the other option is to use locate and type the file name locate mysql.sock If it does not find it try to update the db it uses. updatedb On Wednesday 20 June 2007 00:55:15 John Mancuso wrote: > I would try my best to find a way to login as root or maybe user mysql. > > > John Mancuso > Linux Administrator/MySQL DBA > IT Infrastructure > American Home Mortgage > w: 631-622-6382 > c: 516-652-2475 > > -----Original Message----- > From: Ahamarshan jn [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 19, 2007 12:48 PM > To: John Mancuso > Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server > > mysqld_safe > Starting mysqld daemon with databases from /var/lib/mysql STOPPING > server from pid file /var/run/mysqld/mysqld.pid > 070619 17:40:10 mysqld ended > > --- John Mancuso <[EMAIL PROTECTED]> wrote: > Hiya, > These are the outputs i get when using mysqld_safe --console as root > mysqld_safe --console Starting mysqld daemon with databases from > /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid > 070619 17:45:48 mysqld ended > > > as user > [EMAIL PROTECTED] mysql]$ mysqld_safe --console > Starting mysqld daemon with databases from > /var/lib/mysql > /usr/bin/mysqld_safe: line 363: > /var/log/mysqld/mysqld.log: Permission denied > rm: cannot remove `: > Permission denied > /usr/bin/mysqld_safe: line 371: > /var/log/mysqld/mysqld.log: Permission denied > STOPPING server from pid file > /var/run/mysqld/mysqld.pid > tee: /var/log/mysqld/mysqld.log: Permission denied > 070619 17:46:52 mysqld ended > tee: /var/log/mysqld/mysqld.log: Permission denied > > I could not locate the logdirectory, any pointers to > this please? > - ash# > > > Start mysqld_safe with --console OR > > --error-log=/<logdirectory>/errlog.err > > > > --console will print your errors to the screen > > > > ./mysqld_safe --console > > > > John Mancuso > > Linux Administrator/MySQL DBA > > IT Infrastructure > > American Home Mortgage > > w: 631-622-6382 > > c: 516-652-2475 > > > > -----Original Message----- > > From: Ahamarshan jn [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, June 19, 2007 12:25 PM > > To: John Mancuso > > Subject: RE: ERROR 2002 (HY000): Can't connect to > > local MySQL server > > > > Hiya, > > I could not find .err file anywhere. > > and my mysql.sock file is showing 0 bytes in it. > > - ash# > > > > --- John Mancuso <[EMAIL PROTECTED]> > > > > wrote: > > > Have you looked in your mysql error log in your > > > > data directory? Check > > > > > /<datadir>/<hostname>.err > > > > > > FYI- the locate command needs to be updated. It > > > > can show old info if > > > > > you don't run updatedb frequently > > > > > > > > > John Mancuso > > > Linux Administrator/MySQL DBA > > > IT Infrastructure > > > American Home Mortgage > > > w: 631-622-6382 > > > c: 516-652-2475 > > > > > > -----Original Message----- > > > From: Ahamarshan jn [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, June 19, 2007 11:54 AM > > > To: mysql@lists.mysql.com > > > Subject: ERROR 2002 (HY000): Can't connect to > > > > local MySQL server > > > > > Hi, > > > I was appending Grant previledges to some > > > > databases in mysql; either > > > > > i typed something wrong or there is a bug which I > > > > am uncertain about, > > > > > but what happened was I could not login as su > > > > anymore. I then solved > > > > > this problem by changing grp (chgrp) permission in > > > > /bin/su and it > > > > > works fine. > > > > > > However I could not connect to mysql again > > > > > > When I start mysql I get the following error $ > > > > mysql ERROR 2002 > > > > > (HY000): > > > Can't connect to local MySQL server through socket > > > > > > '/var/lib/mysql/mysql.sock' > > > (111) > > > > > > I could not start nor stop any running mysql I > > > > tried to reboot my > > > > > system hoping that the process will terminate and > > > > restart fresh but > > > > > during shutdown I see the message that mysql > > > > shutdown failed. Upon > > > > > booting again I could not start mysql > > > > > > Even though it shows the file here > > > [EMAIL PROTECTED] locate mysql.sock > > > /var/lib/mysql/mysql.sock > > > > > > the cat of my.cnf is > > > > > > $ cat my.cnf > > > > > > [mysqld] > > > datadir=/var/lib/mysql > > > socket=/var/lib/mysql/mysql.sock > > > > > > # Default to using old password format for > > > > compatibility with old and > > > > > # shorter password hash. > > > # Reference: > > http://dev.mysql.com/doc/mysql/en/Password_hashing.html > > > > old_passwords=1 > > > > > > [mysql.server] > > > user=mysql > > > basedir=/var/lib > > > > > > [mysqld_safe] > > > err-log=/var/log/mysqld/mysqld.log > > > pid-file=/var/run/mysqld/mysqld.pid > > > > > > Also I tried to kill mysql by using PID ie kill > > > > -9 'PID' > > > > > but each time the PID changes when i do ps > > > > -ax|grep mysql and it fails > > > > > to kill mysql. > > > > > > Can some Mysql messiah help me solve this problem. > > > > > > Thank you in advance > > > - ash# > > > PS: I guessed it was quite a common error but when > > > > searched through > > > > > the list it retrived me null post, hence I am > > > > posting this. > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql To > > > > unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] -- Regards Michael Cole -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
