Date: Tue, 08 May 2012 21:51:49 +0100 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: freebsd-questions@freebsd.org Subject: Re: securing MySQL: easiest/best ways? Message-ID: <4FA98765.3020702@infracaninophile.co.uk> In-Reply-To: <20120508155536.505fd7ed@scorpio> References: <898E0B3D-63DD-470C-8F1D-49F478D05C7E@gmail.com> <4FA92EDA.3090809@infracaninophile.co.uk> <20120508155536.505fd7ed@scorpio>
next in thread | previous in thread | raw e-mail | index | archive | help
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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4FA98765.3020702>