Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 27 Aug 2008 15:32:02 +1000
From:      Fraser Tweedale <frase@frase.id.au>
To:        freebsd-questions@freebsd.org
Subject:   Re: mysql-server-5.1.22 system administration docs on FreeBSD 7.0-RELEASE-i386 ?
Message-ID:  <20080827053200.GA7476@bacardi.frase.id.au>
In-Reply-To: <2AEEB7060C5348E8BE65BA6FB951FEBB@a64x23800p>
References:  <2AEEB7060C5348E8BE65BA6FB951FEBB@a64x23800p>

next in thread | previous in thread | raw e-mail | index | archive | help

--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--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080827053200.GA7476>