From owner-freebsd-questions@FreeBSD.ORG  Tue Apr  7 03:28:20 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 90DBA1065794
	for <freebsd-questions@freebsd.org>;
	Tue,  7 Apr 2009 03:28:20 +0000 (UTC) (envelope-from on@cs.ait.ac.th)
Received: from mail.cs.ait.ac.th (mail.cs.ait.ac.th [192.41.170.16])
	by mx1.freebsd.org (Postfix) with ESMTP id E94E18FC0A
	for <freebsd-questions@freebsd.org>;
	Tue,  7 Apr 2009 03:28:19 +0000 (UTC) (envelope-from on@cs.ait.ac.th)
Received: from banyan.cs.ait.ac.th (banyan.cs.ait.ac.th [192.41.170.5])
	by mail.cs.ait.ac.th (8.13.1/8.13.1) with ESMTP id n373O7kQ043386
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO);
	Tue, 7 Apr 2009 10:24:07 +0700 (ICT)
	(envelope-from on@banyan.cs.ait.ac.th)
Received: (from on@localhost)
	by banyan.cs.ait.ac.th (8.14.2/8.12.11) id n373SHdB081955;
	Tue, 7 Apr 2009 10:28:17 +0700 (ICT)
Date: Tue, 7 Apr 2009 10:28:17 +0700 (ICT)
Message-Id: <200904070328.n373SHdB081955@banyan.cs.ait.ac.th>
From: Olivier Nicole <on@cs.ait.ac.th>
To: dave.list@pixelhammer.com
In-reply-to: <49DAC610.6020404@pixelhammer.com> (message from DAve on Mon, 06
	Apr 2009 23:18:40 -0400)
References: <49DAC610.6020404@pixelhammer.com>
X-Virus-Scanned: on CSIM by amavisd-milter (http://www.amavis.org/)
Cc: freebsd-questions@freebsd.org
Subject: Re: Multiple instances of MySQL
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 07 Apr 2009 03:28:20 -0000

Hi,

> Has anyone setup two instances of MySQL on the same server? One running 
> just a client's DBs? Any advice would be helpful.

That is not answering your question directly, but MySQL works finr
over an SSH tunnel.

You'd have your users connect/authenticate with SSH first to establish
the tunnel, then they'd use the tunnel to forward the NySQl
connection. 

Best regards,

Olivier