securing MySQL: easiest/best ways?
jerry at seibercom.net
Tue May 8 21:20:14 UTC 2012
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:
>>> >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
>> 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.
>Maybe you want to run more than one instance of mysql on the same
>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
Disclaimer: off-list followups get on-list replies or get ignored.
Please do not ignore the Reply-To header.
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 488 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20120508/67207b1e/signature.pgp
More information about the freebsd-questions