From owner-freebsd-questions@FreeBSD.ORG Wed Aug 27 05:32:06 2008 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 5203D1065676 for ; Wed, 27 Aug 2008 05:32:06 +0000 (UTC) (envelope-from Fraser@bacardi.frase.id.au) Received: from bacardi.frase.id.au (203-219-142-174.static.tpgi.com.au [203.219.142.174]) by mx1.freebsd.org (Postfix) with ESMTP id 8F61E8FC1D for ; Wed, 27 Aug 2008 05:32:05 +0000 (UTC) (envelope-from Fraser@bacardi.frase.id.au) Received: from bacardi.frase.id.au (localhost [127.0.0.1]) by bacardi.frase.id.au (8.14.2/8.14.2) with ESMTP id m7R5W36U037614 for ; Wed, 27 Aug 2008 15:32:03 +1000 (EST) (envelope-from Fraser@bacardi.frase.id.au) Received: (from Fraser@localhost) by bacardi.frase.id.au (8.14.2/8.14.2/Submit) id m7R5W2F8037613 for freebsd-questions@freebsd.org; Wed, 27 Aug 2008 15:32:02 +1000 (EST) (envelope-from Fraser) Date: Wed, 27 Aug 2008 15:32:02 +1000 From: Fraser Tweedale To: freebsd-questions@freebsd.org Message-ID: <20080827053200.GA7476@bacardi.frase.id.au> References: <2AEEB7060C5348E8BE65BA6FB951FEBB@a64x23800p> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="k1lZvvs/B4yU6o8G" Content-Disposition: inline In-Reply-To: <2AEEB7060C5348E8BE65BA6FB951FEBB@a64x23800p> User-Agent: Mutt/1.5.18 (2008-05-17) Subject: Re: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 27 Aug 2008 05:32:06 -0000 --k1lZvvs/B4yU6o8G Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Aug 26, 2008 at 09:57:10PM -0700, David Christensen wrote: > freebsd-questions: >=20 > 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 application= s. > I've installed mysql-server-5.1.22 via sysinstall from ftp1.us.freebsd.or= g, but > I am unable to figure out how to start it. >=20 >=20 > RTFM: >=20 > # man mysqld > No manual entry for mysqld >=20 > # makewhatis >=20 > # apropos mysql > mysql: nothing appropriate >=20 > # whatis mysql > mysql: nothing appropriate >=20 > I don't understand why apropos and whatis can't find mysql: >=20 > # man mysql >=20 >=20 > Yup, it's there; but that's the client. So is the admin utility: >=20 > # man mysqladmin >=20 >=20 > The FreeBSD Handbook doesn't mention mysql in the TOC: >=20 > http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/index.html >=20 > (Attempting to get the whole thing as HTML locks up my browser.) >=20 >=20 > The mailing list archives didn't help. (Including using Google with site= :). >=20 >=20 > STFW led me to /usr/local/etc/rc.d/mysql-server. Attempting to use that: >=20 > # /usr/local/etc/rc.d/mysql-server start >=20 > # ps -a | grep mysql >=20 > # mysql > ERROR 2002 (HY000): Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) >=20 > # mysqladmin ping > mysqladmin: connect to server at 'localhost' failed > error: 'Can't connect to local MySQL server through socket '/tmp/mysq= l.sock' > (2)' > Check that mysqld is running and that the socket: '/tmp/mysql.sock' e= xists! >=20 >=20 > 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_en= able, > hostname, ifconfig_*, defaultrouter, ntpd*, inetd. mysql-5.1 doesn't se= em to > follow the pattern. Why? >=20 >=20 > Where is the FreeBSD 7.0 system administration documentation for mysqld 5= =2E1? > Specifically, how to start it manually and how to start it at book via th= e rc > system? >=20 >=20 > TIA, >=20 > David >=20 > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.o= rg" Hi, put the following line in /etc/rc.conf: mysql_enable=3D"YES" and run (as root): /usr/local/etc/rc.d/mysql-server start frase --k1lZvvs/B4yU6o8G Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (FreeBSD) iEYEARECAAYFAki05tAACgkQPw/2FZbemTWkqgCfekpAwW67lXKbNGQ+bb+ZzIeM hoIAoKTzMT3y4fIrw3C7UcIls1WBsHOt =DIfD -----END PGP SIGNATURE----- --k1lZvvs/B4yU6o8G--