Date: Tue, 8 May 2012 17:20:00 -0400 From: Jerry <jerry@seibercom.net> To: FreeBSD <freebsd-questions@freebsd.org> Subject: Re: securing MySQL: easiest/best ways? Message-ID: <20120508172000.76ca1bdf@scorpio> In-Reply-To: <4FA98765.3020702@infracaninophile.co.uk> References: <898E0B3D-63DD-470C-8F1D-49F478D05C7E@gmail.com> <4FA92EDA.3090809@infracaninophile.co.uk> <20120508155536.505fd7ed@scorpio> <4FA98765.3020702@infracaninophile.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
--Sig_/PjggBA7e3x52p7yrIg.l+Xa Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Tue, 08 May 2012 21:51:49 +0100 Matthew Seaman articulated: >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. > >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. Actually, it has a lot of advantages. I only run one instance of MySQL; however, for multiple instances, keeping the configs in one location would probably not be advantageous. Someone else mentioned creating a link for the my.cnf file. Since I never touch the my.cnf file once MySQL is setup, I probably would not bother with it, although it is an interesting idea. --=20 Jerry =E2=99=94 Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __________________________________________________________________ --Sig_/PjggBA7e3x52p7yrIg.l+Xa Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (FreeBSD) iQEcBAEBAgAGBQJPqY4JAAoJEF2rWD2do7dNTU0IAI6pSvfgUiX2BdELAPNWJlzf /k6CvOeyCNYLA/c/i8hMtTLzqYwFS2hOK/8vuK+rTnPkGAtifvEQbRVTzMpht2UN x8EuFmMwzYURtOEnitzPxj9zM5LnKnK1fz1kaWvJRHHl46Ku+1CvN4Ia7y7Vo9z9 9juuvSE5gzH8oixtiIwhtI8z5hGfvi2lCl7m6U1ZYxjc9JBgDurIHtE3f+wB52B+ RkfzGuH8eKeNnsLRVeWqCTPlPw8HgxRZz9iaqwZ/TCMJhf1Xq3iew5IlBtLlaNX3 rK7yKoSLiMobGUbnUCJcHZakyZ6Gclg1bbA+RwcAWRfsV+dX7vJ4bvn9r4TcViY= =Vl3T -----END PGP SIGNATURE----- --Sig_/PjggBA7e3x52p7yrIg.l+Xa--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20120508172000.76ca1bdf>