MySQL Forums
Forum List  »  Install & Repo

Advanced Search
New Topic

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Posted by: Tim Moriarity
Date: April 19, 2007 04:06PM

I have the same problem, though I have gathered some more info on my particular problem.

First: the Log file

070419 14:43:58 mysqld started
070419 14:43:58 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
070419 14:43:58 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
070419 14:43:58 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
070419 14:43:58 InnoDB: Started; log sequence number 0 43655
070419 14:43:59 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
070419 14:43:59 mysqld ended


Next OS info:
Slackware 11.0

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
enora doku
December 27, 2004 10:17AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
V
January 14, 2005 05:37PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Aubrey Ramesega
July 07, 2008 03:07AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
angela cornelius
July 07, 2008 04:36PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
laser_zz laser
November 13, 2008 09:05PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Leonardo Sevilla
November 24, 2008 06:51PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Lukas Ziegler
January 28, 2005 10:29AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
hossam hassan
January 30, 2005 08:10PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Bernard Wilmus
February 11, 2005 04:47AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Adrian Villy
February 20, 2005 09:51PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (61)
Jaime Andrés Dávila Guerra
April 09, 2005 05:57PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (61)
Mezbaur Rahman
December 14, 2006 10:48AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
prashant gotmare
December 08, 2006 02:35AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
hossam hassan
January 31, 2005 01:22AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
samit basak
February 02, 2005 03:26AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ssjdillius
February 23, 2005 01:41AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
BreNet GmbH
February 23, 2005 07:03AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Martin Stephen
February 24, 2005 06:58AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
BreNet GmbH
February 24, 2005 11:15AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Marty Van Diest
June 17, 2008 12:35PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
suryadi sabani
May 09, 2008 07:23PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Heinrich Krupp
March 02, 2005 06:46AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket : please read also this thread
Benjamin Gonay
March 03, 2005 02:51AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket : please read also this thread
c c
March 28, 2005 12:43AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Peter Ludanyi
March 28, 2005 02:02AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Chris siefken
March 28, 2005 04:01PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Robin Whitlock
March 29, 2005 10:42AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Stephane Savage
March 29, 2005 05:04PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Tim Moriarity
April 19, 2007 04:18PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
John Speerin
April 07, 2005 12:20PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Ash
April 09, 2005 06:49AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Robert Glastra
April 13, 2005 03:00AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
hatem taleb
April 14, 2005 04:19AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
enora doku
May 03, 2005 09:24AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Paolo Correnti
May 12, 2005 12:33AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Neckros .
November 28, 2005 05:11PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Darryl Allardice
February 19, 2006 04:10PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Andre Vincent
May 02, 2006 05:13AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
thanit kebisiri
May 18, 2006 04:06PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Tina Chang
December 12, 2006 11:01AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
mshanker1
January 05, 2007 10:07PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
mshanker1
January 06, 2007 12:15AM
CONGRATULATION - SOLVED - PERMANENT - BOOKMARK IT!!!!! now...
hello world
January 06, 2007 04:28AM
Re: CONGRATULATION - SOLVED - PERMANENT - BOOKMARK IT!!!!! now...
Tomek Warsztocki
March 13, 2007 05:23AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ACAB ACAB
January 06, 2007 06:43AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Roger Huston
January 10, 2007 02:24PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Roger Huston
January 10, 2007 11:15PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ACAB ACAB
January 12, 2007 06:35PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Genkokitsu
March 12, 2007 12:29PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Genkokitsu
March 12, 2007 01:20PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Paweł None
March 22, 2007 08:35AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Tim Moriarity
April 19, 2007 04:06PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
engin yilmaz
October 10, 2007 12:12PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
mirko corna
October 18, 2007 01:41PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Dzodzo Action
July 08, 2008 06:42AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
ramesh G
November 25, 2008 01:04AM
your mysql server is not running
Arthur Pangilinan
May 13, 2008 06:55AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) FIX
Richard Branham
January 22, 2009 07:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.