From owner-freebsd-questions@FreeBSD.ORG Wed Nov 26 13:57:44 2008 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 4146C1065672 for ; Wed, 26 Nov 2008 13:57:44 +0000 (UTC) (envelope-from valentin.bud@gmail.com) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by mx1.freebsd.org (Postfix) with ESMTP id BA23E8FC18 for ; Wed, 26 Nov 2008 13:57:43 +0000 (UTC) (envelope-from valentin.bud@gmail.com) Received: by ug-out-1314.google.com with SMTP id 30so1382894ugs.39 for ; Wed, 26 Nov 2008 05:57:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=XyHZYxPU73mm5LVHZ+Ov8vLwZN6pnVGjDFPR9mgEckU=; b=r0o+2ZYBswIGixec2Qmg/yySPQeuEVngM/4zH9CGqMliKmugNQq3Ta/kb+Ld3qMsXJ On7eTwYYsEqcQMOqaNvS4z4138eNFj/dJH+u2A29/IMTgZxcKLiLn2dLtrFLdEjPIki3 oh3tvnzHKKS3asngdhj3zkOxP/FQ/quA0EYmI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=qxR8VVSSt1XOaZWZ1HwsDyW43W0Bt6Ax26zlEfa4FUG8b/tBVLL9yY8AE8bOplvxpX c05+fOJfNZ0sWTNzc60wlB7bbmDq/ds2fL+c1MiILb9RRKvvf3kR4O27BBaiT9vSORPn wX+TyF8UABw1TMqwZEkzfzlMNQyc8QfmJ9tAM= Received: by 10.210.58.13 with SMTP id g13mr6009664eba.183.1227707862441; Wed, 26 Nov 2008 05:57:42 -0800 (PST) Received: by 10.210.117.7 with HTTP; Wed, 26 Nov 2008 05:57:42 -0800 (PST) Message-ID: <139b44430811260557n68bb9584ue1d8ef6e41172194@mail.gmail.com> Date: Wed, 26 Nov 2008 15:57:42 +0200 From: "Valentin Bud" To: "=?ISO-8859-1?Q?Ott_K=F6stner?=" In-Reply-To: <492D3FA7.2030304@zzz.ee> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <139b44430811251016l550bc192ue1000c0a09f760a4@mail.gmail.com> <139b44430811260300s2c46cbe9v5866cf108ccf7a01@mail.gmail.com> <492D3FA7.2030304@zzz.ee> Cc: freebsd-questions@freebsd.org Subject: Re: mysqld_multi missing after mysql50-server install X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 26 Nov 2008 13:57:44 -0000 On Wed, Nov 26, 2008 at 2:23 PM, Ott K=F6stner wrote: > Valentin Bud wrote: > >> And of course if there are other possibilities to run 2 mysqld >> instances on one server >> please let me know. >> >> > > There is no limit, how many instances of mysqld you can run. Just > specify different database directories and sockets for each instance. > Something like that: > > $ mysqld --datadir=3D --socket=3D/tmp/ socket> ... I get it. It's like making my own mysqld_multi. I can make multiple /etc/my.cnf and specify on the command line the default data dir, config file, etc and it just works. I will try it and get back with the results. I am thinking of making rc.d files to start the daemons at boot. > > There is no need to run mysqld as root (and better not do that). Just > any regular user is OK for mysqld. I am running mysql from /usr/local/etc/rc.d/mysql-server and it runs as user mysql. Thanks anyway for the heads up :). have a great day, v > > > Greetings, > O.K. > > > -- > Testi oma Interneti kiirust / Test Your Internet speed: > http://speedtest.zzz.ee/ > > > > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.o= rg" >