From owner-freebsd-questions@FreeBSD.ORG  Wed Aug 27 04:57:12 2008
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 2DC89106567E
	for <freebsd-questions@freebsd.org>;
	Wed, 27 Aug 2008 04:57:12 +0000 (UTC)
	(envelope-from dpchrist@holgerdanske.com)
Received: from holgerdanske.com (holgerdanske.com [65.19.145.106])
	by mx1.freebsd.org (Postfix) with SMTP id 0238F8FC14
	for <freebsd-questions@freebsd.org>;
	Wed, 27 Aug 2008 04:57:11 +0000 (UTC)
	(envelope-from dpchrist@holgerdanske.com)
Received: from a64x23800p ([64.142.42.100]) by holgerdanske.com for
	<freebsd-questions@freebsd.org>; Tue, 26 Aug 2008 21:57:11 -0700
From: "David Christensen" <dpchrist@holgerdanske.com>
To: <freebsd-questions@freebsd.org>
Date: Tue, 26 Aug 2008 21:57:10 -0700
Message-ID: <2AEEB7060C5348E8BE65BA6FB951FEBB@a64x23800p>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 11
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
Thread-Index: AckH/nUidd1CyhnQQLifZa88CwVoEQ==
Subject: mysql-server-5.1.22 system administration docs on FreeBSD
	7.0-RELEASE-i386 ?
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: Wed, 27 Aug 2008 04:57:12 -0000

freebsd-questions:

I am a FreeBSB noob who has read http://nostarch.com/abs_bsd2.htm and is
attempting to build a FreeBSD 7.0 box for Apache/ MySQL/ Perl applications.
I've installed mysql-server-5.1.22 via sysinstall from ftp1.us.freebsd.org, but
I am unable to figure out how to start it.


RTFM:

    # man mysqld
    No manual entry for mysqld

    # makewhatis

    # apropos mysql
    mysql: nothing appropriate

    # whatis mysql
    mysql: nothing appropriate

I don't understand why apropos and whatis can't find mysql:

    # man mysql


Yup, it's there; but that's the client.  So is the admin utility:

    # man mysqladmin


The FreeBSD Handbook doesn't mention mysql in the TOC:

    http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/index.html

(Attempting to get the whole thing as HTML locks up my browser.)


The mailing list archives didn't help.  (Including using Google with site:).


STFW led me to /usr/local/etc/rc.d/mysql-server.  Attempting to use that:

    # /usr/local/etc/rc.d/mysql-server start

    # ps -a | grep mysql

    # mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

    # mysqladmin ping
    mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(2)'
    Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!


I've been fumbling my way around FreeBSD, and thus far have been able to get
things working via /etc/rc.d/* scripts and/or /etc/rc.conf --  (apache_enable,
hostname, ifconfig_*, defaultrouter, ntpd*, inetd.   mysql-5.1 doesn't seem to
follow the pattern.  Why?


Where is the FreeBSD 7.0 system administration documentation for mysqld 5.1?
Specifically, how to start it manually and how to start it at book via the rc
system?


TIA,

David