From owner-freebsd-questions@FreeBSD.ORG Tue May 8 20:52:00 2012 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 D13D41065687 for ; Tue, 8 May 2012 20:52:00 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) by mx1.freebsd.org (Postfix) with ESMTP id 55F118FC28 for ; Tue, 8 May 2012 20:52:00 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [IPv6:2001:8b0:151:1:fa1e:dfff:feda:c0bb]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.5/8.14.5) with ESMTP id q48KpuOA047051 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO) for ; Tue, 8 May 2012 21:51:56 +0100 (BST) (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: OpenDKIM Filter v2.5.2 smtp.infracaninophile.co.uk q48KpuOA047051 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1336510316; bh=hVOMlXMpms9PU0FBWkewLUyto6gghQlrw1Hs+tJTir4=; h=Date:From:To:Subject:References:In-Reply-To:Cc:Content-Type: Message-ID:Mime-Version; b=yhsXa4fMOwzFhUT5UjlBBYjiEOKzBledo7Pgw2Nc1SSOKSxsV2aK9zO+Cbtv6uKp2 NIRnJXh5xTR7uh7xSR0RRoh9oZDmCQbo8Uezm+NmHhYTEzyW1FIrVVDIOeLmZtjAUt HSRwHDp2Aal3GYXsfrHHOSJ8sIB9juxSzuwgGw1c= Message-ID: <4FA98765.3020702@infracaninophile.co.uk> Date: Tue, 08 May 2012 21:51:49 +0100 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:12.0) Gecko/20120428 Thunderbird/12.0.1 MIME-Version: 1.0 To: freebsd-questions@freebsd.org References: <898E0B3D-63DD-470C-8F1D-49F478D05C7E@gmail.com> <4FA92EDA.3090809@infracaninophile.co.uk> <20120508155536.505fd7ed@scorpio> In-Reply-To: <20120508155536.505fd7ed@scorpio> X-Enigmail-Version: 1.4.1 OpenPGP: id=60AE908C Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigEDB13CCEF32F2E943DA7E716" X-Virus-Scanned: clamav-milter 0.97.4 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.0 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, DKIM_ADSP_ALL,DKIM_SIGNED,T_DKIM_INVALID autolearn=no version=3.3.2 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on lucid-nonsense.infracaninophile.co.uk Subject: Re: securing MySQL: easiest/best ways? 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: Tue, 08 May 2012 20:52:01 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigEDB13CCEF32F2E943DA7E716 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On 08/05/2012 20:55, Jerry wrote: > On Tue, 08 May 2012 15:34:02 +0100 > Matthew Seaman articulated: >=20 >> >Sounds almost as if the my.cnf you've been editing is not the my.cnf >> >that your mysql instance is using. IIRC there was some talk about >> >moving from the usual BSD-ish /var/db/mysql/my.cnf to >> >/usr/local/etc/my.cnf (no doubt under some insidious influence from >> >Linux.) > The first time I ever looked for "my.cnf" I had expected to find it in > "/usr/local/etc". Since so many configuration files are stored there, > it just seemed like a natural place for it to be located. IMHO, a > centralized repository for configuration files greatly simplifies > system maintenance. Yeah. It's no big deal. But... Maybe you want to run more than one instance of mysql on the same machine= =2E Or you want to move the data directory lock, stock and barrel onto a different server. Maybe it's some ultra fancy fail-over setup with a data dir shared between two servers. Keeping the configs with the data does have a few advantages. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate JID: matthew@infracaninophile.co.uk Kent, CT11 9PW --------------enigEDB13CCEF32F2E943DA7E716 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.16 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk+ph2wACgkQ8Mjk52CukIxCoACfVEpgdQxhflipusZCoCoJHDk2 SjAAn2dVGuQwY/WAzKgjN4NuUpVxkQUL =2P6/ -----END PGP SIGNATURE----- --------------enigEDB13CCEF32F2E943DA7E716--