MySQL Forums
Forum List  »  Install & Repo

Advanced Search
New Topic

Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Posted by: Bubba Jones
Date: January 04, 2006 02:55PM

When I had some issues with my data on a development server, I dumped my data and deleted /var/lib/mysql

I created the directory and standard database files with:
mysql_install_db

Then I chown'd the directory and sub directories to mysql.mysql.

As root, mysql ran fine. As a local user (non-root) I got the Error 2002 and didn't understand why...

I had to add read permissions for other users to /var/lib/mysql so it could check for the socket.
When I ran "mysql_install_db", it gave /var/lib/mysql root permissions only.

Just a heads up.

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/lib/mysql/mysql.sock' (2)
Vacheh Sardarian
May 29, 2005 01:34AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Ricardo Garcia Chavarry
October 08, 2005 03:51PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
erick adienge
November 10, 2005 12:07PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Paul KOENIG
November 19, 2005 03:33AM
Unable to start mysqld
Abhijit Mapgaonkar
March 03, 2007 04:06AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Cristea Cristina
June 11, 2008 03:32AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
John G
September 01, 2008 06:23AM
Mac OS 10.5 Semi-Solution
Jon Ohliger
January 08, 2009 02:01PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Christine Pursley
November 15, 2005 03:53PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Nastase Catalin
November 26, 2005 05:11PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ox
November 28, 2005 09:43AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Ismael Ortiz Estrada
December 01, 2005 08:09PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Chan Rays
December 03, 2005 05:48PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Sohail Asif Khan
April 21, 2006 11:41AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
gourav kumar
August 17, 2006 04:52AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
rakesh krishna
May 16, 2008 11:45PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
John G
August 31, 2008 01:23PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Rajinesh Chintala
December 06, 2005 11:57PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Rajinesh Chintala
December 07, 2005 12:39AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Wan Ghazali Mohd Rasdi
January 31, 2008 08:30PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Lynn Etheredge
September 24, 2008 09:46AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Craig S
November 28, 2005 07:29PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Marco Beijen
October 27, 2009 11:46PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Craig S
November 28, 2005 07:36PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Jason Belec
December 13, 2005 02:44PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Jakub TCP
December 15, 2005 09:07AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Bubba Jones
January 04, 2006 02:55PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Jason Belec
January 04, 2006 06:56PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Sohail Asif Khan
March 11, 2006 03:30AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
cakra semar
April 11, 2007 03:08AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
liam o'connor
April 20, 2006 11:51PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Dennis Yu
July 17, 2006 03:32AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Sohail Asif Khan
April 21, 2006 11:40AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Jason
July 02, 2006 02:01PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Terry James
July 20, 2006 05:32AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Adam Klemke
February 04, 2007 05:44AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
adil ismail
September 12, 2007 01:01AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Rajeev Kumar
April 04, 2007 06:41AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Cihan KIZILGUL
January 19, 2007 12:08AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
SARA SPITONI
January 24, 2007 10:19AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Bob Macpherson
February 01, 2007 10:29PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Paul Lynch
February 09, 2007 10:45AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Iain MacGranjthin
February 27, 2007 04:47AM
WHY this ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
FRANCOIS LISSI
March 05, 2007 12:23PM
SOLUTION: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Noel Hall
March 12, 2007 08:58AM
Re: SOLUTION: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
reynie mahilum
September 03, 2007 08:27PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
karthik santhanam
March 22, 2007 10:44PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
mike
March 22, 2007 11:23PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Jan Jaderný
March 23, 2007 07:07AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Cam Blair
April 03, 2007 10:49AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Mauricio Martinez
April 03, 2007 04:35PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Walter Mendizabal
December 29, 2007 10:09AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Walter Mendizabal
December 29, 2007 10:07AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
iSLAMKENT iSLAMi SiTE iSLAMi SOHBET
April 04, 2007 12:56AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
trstn
April 04, 2007 07:47AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
rakesh krishna
May 16, 2008 11:48PM
Solution for: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Ibrahim Assaab
June 07, 2008 02:00AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
tianxing yi
September 14, 2008 01:31AM
Re: ERROR 2002 (HY000): Solution !
Howard Hebbler
April 14, 2007 01:24PM
Re: ERROR 2002 (HY000): Mac OS X 10.5.1 & MAMP
Levon Spradlin
January 23, 2008 05:16PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Thinakaran Chelliah
July 17, 2007 03:39AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Neel basu
September 06, 2007 08:26AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Adam Bragg
September 08, 2007 08:44AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Neel basu
September 11, 2007 12:18AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
abzim le kabyle
December 14, 2007 04:03PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Walter Mendizabal
December 29, 2007 10:03AM
One solution that worked (WITHOUT reinstalling everything)
Meta Stable
February 19, 2008 09:16AM
Re: One solution that worked (WITHOUT reinstalling everything)
Aditya Darbha
March 03, 2008 04:45AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Misael Jabines
April 11, 2008 08:16PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Aimin Huang
September 01, 2008 08:00PM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Ro Nin
February 09, 2009 05:05AM
SOLUTION TO THE PROBLEM
Manuel Sosa
April 15, 2009 11:56AM
Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
art martin
June 14, 2009 12:52PM
Possible solution to the issue: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Umesh Shastry
July 28, 2009 02:27AM
Solution
koteswara Rao muntha
October 21, 2009 06:18PM
Re: (EVEN SIMPLER) Solution (for mac os x)
Faddah Steve Yuetsu Wolf
October 31, 2009 12:46PM
Re: (EVEN SIMPLER) Solution (for mac os x)
Faddah Steve Yuetsu Wolf
October 31, 2009 12:46PM


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.