From owner-freebsd-questions@FreeBSD.ORG  Mon Sep 26 20:05:48 2005
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 38E0816A41F
	for <freebsd-questions@freebsd.org>;
	Mon, 26 Sep 2005 20:05:48 +0000 (GMT) (envelope-from kdk@daleco.biz)
Received: from ezekiel.daleco.biz (southernuniform.com [66.76.92.18])
	by mx1.FreeBSD.org (Postfix) with ESMTP id BC64043D48
	for <freebsd-questions@freebsd.org>;
	Mon, 26 Sep 2005 20:05:45 +0000 (GMT) (envelope-from kdk@daleco.biz)
Received: from [192.168.2.2] ([69.27.149.254])
	by ezekiel.daleco.biz (8.13.1/8.13.1) with ESMTP id j8QK4XUW091496;
	Mon, 26 Sep 2005 15:04:58 -0500 (CDT) (envelope-from kdk@daleco.biz)
Message-ID: <43385447.2000708@daleco.biz>
Date: Mon, 26 Sep 2005 15:04:23 -0500
From: Kevin Kinsey <kdk@daleco.biz>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.7.11) Gecko/20050923
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: eoghan <freebsd@redry.net>
References: <A9542760-015D-431A-9CD5-315BA5D60B7C@redry.net>
In-Reply-To: <A9542760-015D-431A-9CD5-315BA5D60B7C@redry.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Cc: freebsd-questions@freebsd.org
Subject: Re: mysql port install
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 26 Sep 2005 20:05:48 -0000

eoghan wrote:

> Hello
> Im having a problem getting mysql (version 4.1.14) to work. Im  
> installing
> from ports, which was updated today. Each time i try #>mysql
> is get: ERROR 2002 (HY000): Can't connect to local MySQL server 
> through socket '/tmp/mysql.sock' (2)
> mysql.sock isnt in /tmp/ which is a problem. The manual and
> searches  say that this means the server usually isnt running,
> so type mysqld  to start it. But i just get command not found.
> The only reference to  mysqld is in /usr/local/man/man1/mysql.1.gz
> I was wondering if someone had any luck getting this port
> installed?  Im using freeBSD 5.3 by the way.
> Thanks
> Eoghan



<<Surely this is a FAQ by now, and a search of the
list archives would provide the answer.  In particular,
this is _not_ hackers@ material, which might account for
the fact that I'm sounding a little terse here.  It's nothing
personal, I assure you.  I'm redirecting the cc to the appropriate
list.>>

Look for a "mysql-server.sh" script under /usr/local/etc/rc.d.  As root,
type "/usr/local/etc/rc.d/mysql-server.sh start".  The server *should* 
start.

To make sure it does, add "mysql_enable=YES" to /etc/rc.conf.
This is part of the "RCng" system, and it's mentioned about
a hundred-eleventy times in ***/usr/ports/UPDATING***.  (Didja
read that one? ;-)

mysqld doesn't live in your $PATH on a FreeBSD system, so
you can't expect to call it with simply "mysqld".  For its own
reasons, AFAIK, it's at /usr/local/libexec/mysqld....

I have one server from a long time ago where I simply started
MySQL from cron(8) thus (which goes to show that I had similar
issues once upon a time and shouldn't be too hard on a newb, eh?):

@reboot   /usr/local/libexec/mysqld -u mysql 
--pid-file=/usr/local/var/secure.pid -h /var/db/mysql/ &

So, whatever boils your fish is fine.  But *lots* of us have MySQL
working.  ;-)

HTH,

Kevin Kinsey