From owner-freebsd-questions@FreeBSD.ORG  Thu Jul  5 01:37:52 2007
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 [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id DA72E16A400
	for <freebsd-questions@freebsd.org>;
	Thu,  5 Jul 2007 01:37:52 +0000 (UTC)
	(envelope-from bob@a1poweruser.com)
Received: from mta15.adelphia.net (mta15.mail.adelphia.net [68.168.78.77])
	by mx1.freebsd.org (Postfix) with ESMTP id 7298613C459
	for <freebsd-questions@freebsd.org>;
	Thu,  5 Jul 2007 01:37:52 +0000 (UTC)
	(envelope-from bob@a1poweruser.com)
Received: from laptop ([76.190.225.105]) by mta15.adelphia.net
	(InterMail vM.6.01.05.04 201-2131-123-105-20051025) with SMTP
	id <20070705013750.IHUM26470.mta15.adelphia.net@laptop>;
	Wed, 4 Jul 2007 21:37:50 -0400
From: "Bob" <bob@a1poweruser.com>
To: "Andrew Falanga" <af300wsm@gmail.com>,
	"User Questions" <freebsd-questions@freebsd.org>
Date: Wed, 4 Jul 2007 21:37:49 -0400
Message-ID: <NBECLJEKGLBKHHFFANMBAEIJCEAA.bob@a1poweruser.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0)
In-Reply-To: <340a29540707041500g25289b6la1aec3340b5cd628@mail.gmail.com>
Importance: Normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
Cc: 
Subject: RE: How does one start mysql after installing from ports
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: bob@a1poweruser.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: Thu, 05 Jul 2007 01:37:52 -0000

To autostart mysql at boot add this to /etc/rc.conf
mysql_enable="YES"

Add this to /etc/rc.conf to direct to use location where there is a large
enough free disk space
to hold your databases
mysql_dbdir="/usr/local/mysql"

To start or stop mysql server do this
/usr/local/share/mysql/mysql.server start
/usr/local/share/mysql/mysql.server stop

You have to tell mysql to create its internel control db
by running this command one time first before trying to create databases.
mysql_install_db --user=mysql

To verify mysql is operational issue these commands
mysqladmin version
mysqladmin variables

To start command line session with mysql server to
create a DB enter
mysql -u root

The online mysql manual is at
http://dev.mysql.com/doc/refman/5.0/en/index.html