From owner-freebsd-questions@FreeBSD.ORG Sun Jan 3 13:10:37 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 AAAA6106566B for ; Sun, 3 Jan 2010 13:10:37 +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 8F8F88FC0A for ; Sun, 3 Jan 2010 13:10:37 +0000 (UTC) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1NRQE9-0004UY-4x for freebsd-questions@freebsd.org; Sun, 03 Jan 2010 05:10:37 -0800 Message-ID: <27001411.post@talk.nabble.com> Date: Sun, 3 Jan 2010 05:10:37 -0800 (PST) From: jaymax To: freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: jaymax36@gmail.com Subject: 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: Sun, 03 Jan 2010 13:10:37 -0000 HELP! NEEDED URGENTLY 7.2-RELEASE #0: Fri May 1 08:49:13 UTC 2009 installed /usr/ports/databases/mysql54-server from ports Installation seemed to go to completion - OK but # /usr/local/bin/mysql_install_db - ERRORS listed as ==> Installing MySQL system tables... 091230 13:35:02 [ERROR] The update log is no longer supported by MySQL in version 5.0 and above. It is replaced by the binary log. 091230 13:35:02 [Note] Falcon: unable to open system data files. 091230 13:35:02 [Note] Falcon: creating new system data files. 091230 13:35:03 [Warning] Forcing shutdown of 2 plugins OK Filling help tables... 091230 13:35:04 [ERROR] The update log is no longer supported by MySQL in version 5.0 and above. It is replaced by the binary log. 091230 13:35:05 [Warning] Forcing shutdown of 2 plugins OK Then running /usr/local/bin/mysqld_safe & ==> 091230 17:45:16 mysqld_safe Logging to '/disk02/db/mysql/DATA/ax.lall.com.err'. 091230 17:45:16 mysqld_safe Starting mysqld daemon with databases from /disk02/db/mysql/DATA 091230 17:45:16 mysqld_safe mysqld from pid file /disk02/db/mysql/DATA/ax.lall.com.pid ended 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) Tried various strategies for mysql.sock problems as suggested in thre forum but can't seem to get any to work, if someone has any ideas they will be much appreciated. Thanks! PS: Settings in rc.conf mysql_enable="YES" mysql_limits="YES" mysql_dbdir="/disk02/db/mysql/DATA" mysql_args="" In my.cnf file [client] socket=/usr/tmp/mysql.sock [mysqld] socket=/usr/tmp/mysql.sock /usr/tmp permissions set to drwxrwxrwt datadir = mysql:mysql ownership HELP! NEEDED URGENTLY -- View this message in context: http://old.nabble.com/Possible-mysql.sock-problem-%7C-ERROR-2002-%28HY000%29-tp27001411p27001411.html Sent from the freebsd-questions mailing list archive at Nabble.com.