From owner-freebsd-questions@FreeBSD.ORG Sat Apr 15 03:12:49 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5705816A402 for ; Sat, 15 Apr 2006 03:12:49 +0000 (UTC) (envelope-from jekillen@prodigy.net) Received: from smtp114.sbc.mail.mud.yahoo.com (smtp114.sbc.mail.mud.yahoo.com [68.142.198.213]) by mx1.FreeBSD.org (Postfix) with SMTP id DFDDB43D46 for ; Sat, 15 Apr 2006 03:12:48 +0000 (GMT) (envelope-from jekillen@prodigy.net) Received: (qmail 65982 invoked from network); 15 Apr 2006 03:12:48 -0000 Received: from unknown (HELO ?75.7.236.226?) (jekillen@prodigy.net@75.7.236.226 with plain) by smtp114.sbc.mail.mud.yahoo.com with SMTP; 15 Apr 2006 03:12:48 -0000 Mime-Version: 1.0 (Apple Message framework v622) Content-Transfer-Encoding: 7bit Message-Id: Content-Type: text/plain; charset=US-ASCII; format=flowed To: freebsd-questions From: jekillen Date: Fri, 14 Apr 2006 20:12:47 -0700 X-Mailer: Apple Mail (2.622) Subject: quick solution addemdum X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 15 Apr 2006 03:12:49 -0000 In addition to the mysql, quick solution question: the error is literally: ERROR 2002 [HY000]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) I thought that the server would create the mysql.sock file when it started if it didn't exist so as root I removed it. I received the same error as above accept for (2) on the end rather than (61); I thought back to linux use days and vaguely remembered having a similar problem and never did find out how the mysql.sock file is created. Impatience won over laziness and I did read the O'Reilly MySQL Reference Manual and it did say lots about protecting the mysql.sock file but not how to recreate it if it has been eliminated. I guess that's the essence of my original question: How do you recreate the mysql.sock file if it has been eliminated or in this case corrupted by a system power failure. Thanks: JK