From owner-freebsd-questions@FreeBSD.ORG Tue May 8 21:20:13 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 E34C3106564A for ; Tue, 8 May 2012 21:20:13 +0000 (UTC) (envelope-from jerry@seibercom.net) Received: from mail-yx0-f182.google.com (mail-yx0-f182.google.com [209.85.213.182]) by mx1.freebsd.org (Postfix) with ESMTP id 775488FC17 for ; Tue, 8 May 2012 21:20:12 +0000 (UTC) Received: by yenl8 with SMTP id l8so1182422yen.13 for ; Tue, 08 May 2012 14:20:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=seibercom.net; s=google; h=date:from:to:subject:message-id:in-reply-to:references:followup-to :reply-to:organization:x-mailer:face:mime-version:content-type; bh=VP3agwTNPfbngQLFf4dttF9sr6Fh+NTNQvu+adO/Ihs=; b=Vl7EzMuhzF0gfoY99CFrsB2LRogjY8N0wVTQp0h4DEu1QMo+Rg3KB/wI94MaNsjgKy EjNaD1SGqDcZoMP9bzGd/7VEK06PmWNZoriox0nsRUCr2LX0F8QlT0Xb4ygUhnXDFFwQ xz9C+mdj2meP+FaGwuL/d2F0d8DnYcqt0t8fk= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20120113; h=date:from:to:subject:message-id:in-reply-to:references:followup-to :reply-to:organization:x-mailer:face:mime-version:content-type :x-gm-message-state; bh=VP3agwTNPfbngQLFf4dttF9sr6Fh+NTNQvu+adO/Ihs=; b=UZyAQN8rvuHFajb2iaiNZNHe14PI1wUqiYI2JXLYigTLsCrIqbjcM1x1SeSMRn7rSs enXfM4JhpVTP5VfcGLZAy9tRrD3VNe3LfXFc3zm3Xcts+cZ30E4rNcKUuyz6NcPvyGOR c5w2a99CJ6C6CnDdylRz7NRw13SS3WBaaRCeEFKGj8hJniEu28WVkfRo2sNdTQgRXtJn y/73BfEpv9aHVw2c7b/QanneVqVxj/MKJZjqsbRf9FljNBZbI40AN/Y/1IgFJTv9TacQ Jlzk6E2AfGMFi891icAQiiNRcMqNytnJfLc40d7XF9AKKm7/nqV9SB0swfJDGjLXZ0vp ezYg== Received: by 10.236.185.167 with SMTP id u27mr11513518yhm.32.1336512012097; Tue, 08 May 2012 14:20:12 -0700 (PDT) Received: from scorpio.seibercom.net (cpe-076-182-104-150.nc.res.rr.com. [76.182.104.150]) by mx.google.com with ESMTPS id u2sm2152010yhe.8.2012.05.08.14.20.10 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 08 May 2012 14:20:11 -0700 (PDT) Received: from scorpio (localhost [127.0.0.1]) (using TLSv1.2 with cipher DHE-RSA-AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: jerry@scorpio.seibercom.net) by scorpio.seibercom.net (Postfix) with ESMTPSA id 3VnDB13cSqz2CG46 for ; Tue, 8 May 2012 17:20:09 -0400 (EDT) Date: Tue, 8 May 2012 17:20:00 -0400 From: Jerry To: FreeBSD 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> Followup-To: FreeBSD Organization: seibercom.net X-Mailer: Claws Mail 3.8.0 (GTK+ 2.24.6; amd64-portbld-freebsd8.2) Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAHlBMVEUAAABYRlwJCw4FAgAIBwKprDkBAQFQLR0BAgCir7VRttp8AAACAUlEQVQ4jZWUTYvbMBCGTVl8V2hX6Gg5G5FbWQdBj0lEfE7BhN4cyzi5Wt1E5L70roWy6N92xok/skkP+5IYrMcz78xIduDWpNM3vFzuA/jX5EY1AI6KHFwW/CzFuQAwqUBbV12p+CzIh6Awq7sg33pn5D64SQXAexffeuQlA/L35RrkaB551OjGfP/cAO8mCNaDcgvfky5ijoD0pAXlCQCnljiAjsJD9Ax05Ko5sZxbnLQcmM+dZg5IjREfZrWIHK0JuwU68pAGwHvfRxBundRzTxxz3r9dNUikPsEihjz2Dc4kjp1hKsJGuot4EDxaxzMoC7XqhxhOSfZrTS6gSX1JVdjp+o1PvWfekXgw3WL0g70nDEwA0H0HQsEZc8sTmFMTkWUfYWC/vdR1zQy3xLQgLwzu90QnlnFLjeiGWBjwhb4Sa42IqOg2qqS4O1/zhKokFUb1Q8Rj4Eb69WVflXEehJ35DgChVTE5n50eaGyMLOfH8AOodoSM4PVYAQgQdBulOa+knklYks3vAuQ+uX492lTl+A+e8qBV2AKoXalVKFfyuUp0pUp1ARaUHh82lv9MN+Ig7CZtgE6FNYvjlywT2VP2dMgOG46gTIWcqdfvuwyXNz0oMJNd/N5lh1YNiJt19ADTUo3VuFSNeQwVqRSrGjSCp53fk2g+Mvfk/gfoPxHeUS8MH9vRAAAAAElFTkSuQmCC Mime-Version: 1.0 Content-Type: multipart/signed; micalg=PGP-SHA1; boundary="Sig_/PjggBA7e3x52p7yrIg.l+Xa"; protocol="application/pgp-signature" X-Gm-Message-State: ALoCoQnZK9o2c50A93To9h2KgoYmmWrnH2ieVnGbRr06QcIAXOX4jXrfEAvCMtCgnLgejRt7kyAj Subject: Re: securing MySQL: easiest/best ways? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: FreeBSD List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 08 May 2012 21:20:14 -0000 --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--