From owner-freebsd-questions@FreeBSD.ORG Thu Jan 7 20:15:21 2010 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3C90C1065670 for ; Thu, 7 Jan 2010 20:15:21 +0000 (UTC) (envelope-from bounces@nabble.com) Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by mx1.freebsd.org (Postfix) with ESMTP id 1ED2F8FC19 for ; Thu, 7 Jan 2010 20:15:20 +0000 (UTC) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1NSylM-0003Wp-Gj for freebsd-questions@freebsd.org; Thu, 07 Jan 2010 12:15:20 -0800 Message-ID: <27066296.post@talk.nabble.com> Date: Thu, 7 Jan 2010 12:15:20 -0800 (PST) From: jaymax To: freebsd-questions@freebsd.org In-Reply-To: <4B409F3A.80405@infracaninophile.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: jaymax36@gmail.com References: <27001411.post@talk.nabble.com> <4B409F3A.80405@infracaninophile.co.uk> Subject: Re: Possible mysql.sock problem | ERROR 2002 (HY000) 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: Thu, 07 Jan 2010 20:15:21 -0000 Thanks !!! Got it resolved after adding mysql_socket="/usr/tmp/mysql.sock" to the rc.conf file Removing the /etc/my.cnf file as the aetting were redundant with those used in the compilation deinstalling and reinstalling both the server and the client Matthew Seaman-2 wrote: > > jaymax wrote: > >> Direct start from script /usr/local/etc/rc.d/mysql-server start fails >> also >> >> And running /usr/local/bin/mysql ==> >> ERROR 2002 (HY000): Can't connect to local MySQL server through socket >> '/usr/tmp/mysql.sock' (2) >> > > There's a $mysql_socket rc.conf variable you need to set as well. > >> Settings in rc.conf >> mysql_enable="YES" >> mysql_limits="YES" >> mysql_dbdir="/disk02/db/mysql/DATA" >> mysql_args="" > mysql_socket="/usr/tmp/mysql.sock" > > (Although if /usr/tmp is set to mode 1777, what's the benefit of using > that > location rather than the default /tmp/mysql.sock ?) > > Initially they were on their own file systems both ran into problems of > restricted sizes and overflow condition. > > > Judging by the complaints about 'update log no longer supported' I'm > guessing that there is somewhere a my.cnf or a .my.cnf file filled with > configuration settings appropriate to a much earlier version of MySQL. > A good strategy is to grab one of the sample .cnf files from > /usr/local/share/mysql (according to the capabilities of your server) > copy that into ${mysql_dbdir}/my.cnf and edit to make any local > customizations. > > Aparently ignored after > -- View this message in context: http://old.nabble.com/Possible-mysql.sock-problem-%7C-ERROR-2002-%28HY000%29-tp27001411p27066296.html Sent from the freebsd-questions mailing list archive at Nabble.com.