From owner-freebsd-questions@FreeBSD.ORG  Sat May  7 15:33:48 2005
Return-Path: <owner-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 6C67E16A4DB
	for <freebsd-questions@freebsd.org>;
	Sat,  7 May 2005 15:33:48 +0000 (GMT)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.199])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 1728B43DB4
	for <freebsd-questions@freebsd.org>;
	Sat,  7 May 2005 15:33:48 +0000 (GMT)
	(envelope-from christopher.hodgins@gmail.com)
Received: by wproxy.gmail.com with SMTP id 71so1147748wra
	for <freebsd-questions@freebsd.org>;
	Sat, 07 May 2005 08:33:45 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
	s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=UhUhMTepZQFLRBTM1sGyJMiS/AdfmATE30HwPN+KKrNjj6Ux0uGHMETy8jDmp4E62+xoDW4bsTNVz9wsyH9FcYB29v64YmA01ATSDmRr3QkG8Yei+tfZMdzZRXVVe3L9YnrtP05O3eSyUhaG0+kMc+41Ws3108N/sHQWTqSzUtc=
Received: by 10.54.69.3 with SMTP id r3mr1497844wra;
        Sat, 07 May 2005 08:33:45 -0700 (PDT)
Received: by 10.54.82.6 with HTTP; Sat, 7 May 2005 08:33:45 -0700 (PDT)
Message-ID: <63c3899e0505070833315cf7c1@mail.gmail.com>
Date: Sat, 7 May 2005 16:33:45 +0100
From: Chris Hodgins <christopher.hodgins@gmail.com>
To: Paul Keyes <paul_s_keyes@yahoo.ca>
In-Reply-To: <20050506175218.40330.qmail@web32107.mail.mud.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <20050506175218.40330.qmail@web32107.mail.mud.yahoo.com>
cc: freebsd-questions@freebsd.org
Subject: Re: starting mysql server automatically
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
Reply-To: Chris Hodgins <christopher.hodgins@gmail.com>
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: Sat, 07 May 2005 15:33:48 -0000

On 5/6/05, Paul Keyes <paul_s_keyes@yahoo.ca> wrote:
> Hi All,
>=20
> I'm setting up a server running Freebsd 5.3  I have
> mysql running well but I can't seem to get it to start
> automatically at boot time.  I can only start it as
> root with the command:
> mysqld_safe --user=3Dmysql &
>=20
> (when I do this everything works fine)
>=20
> I tried installing the mysql.server sript as:
> /usr/local/etc/rc.d/mysql.server.sh
> but when I try to run it manually I get this:
> ./mysql.server.sh: 102: Syntax error: Bad for loop
> variable
>=20
> What is the best way to get the mysql server running
> automatically when the computer boots?
>=20
> Thanks,
> Paul
>=20

Make sure this line appears in /etc/rc.conf:
mysql_enable=3D"YES"

Then reboot and you should be able to see it in sockstat:

$ sockstat -4 | grep mysql
mysql    mysqld     529   3  tcp4   *:3306                *:*

If that still does not work then you might want to post you
mysql-server.sh file so we can see if you have any obvious problems
with it.

Chris