From owner-freebsd-questions@FreeBSD.ORG Wed Jan 12 09:37:52 2005 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5763816A4CE for ; Wed, 12 Jan 2005 09:37:52 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.193]) by mx1.FreeBSD.org (Postfix) with ESMTP id E30B743D5F for ; Wed, 12 Jan 2005 09:37:51 +0000 (GMT) (envelope-from humprhey@gmail.com) Received: by rproxy.gmail.com with SMTP id 40so180520rnz for ; Wed, 12 Jan 2005 01:37:51 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:subject:references:in-reply-to:content-type:content-transfer-encoding; b=K/0H65YuZ00jYYSoDDyVZDlj4YAaqyidi7zix+569nwX5L6Agoq5Rt92QDhGoijSEs7Gh2XgCC8OrusJfuU+DRHyAnuzAFdS2ABNrQvdQMG6rB/MT0ixaHcF+eUNl8zVJjK5XaMp4yqwzvZwzJ9cSU2zFw1Xm9eMS3kql1OGpRg= Received: by 10.38.8.48 with SMTP id 48mr169099rnh; Wed, 12 Jan 2005 01:37:51 -0800 (PST) Received: from ?192.168.1.4? ([80.38.223.137]) by smtp.gmail.com with ESMTP id 62sm7995rna.2005.01.12.01.37.50; Wed, 12 Jan 2005 01:37:51 -0800 (PST) Message-ID: <41E4EFEF.9090400@gmail.com> Date: Wed, 12 Jan 2005 10:37:51 +0100 From: Darksidex User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: FreeBSD Questions References: <20050112101204.L1613@kenmore.kozy-kabin.nl> In-Reply-To: <20050112101204.L1613@kenmore.kozy-kabin.nl> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: Trouble starting MySQL X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 12 Jan 2005 09:37:52 -0000 Colin J. Raven wrote: >Greetings all, >I installed MySQL from ports (mysql-4.1.7) >then tried to start it. Nothing doing - wo way. > >Starting it from /usr/loca/etc/rc.d/mysql-server.sh nothing happens. No >error message is emitted, but no running instance of mysql either. > >Two other possible options appeared to present themselves: >----------------------------------------------------------------- >Option number one: > >/usr/local/libexec/mysqld > >Which yielded this output: > >050112 01:19:57 [ERROR] Fatal error: Please read "Security" section of >the manual to find out how to run mysqld as root! >050112 01:19:57 [ERROR] Aborting >050112 01:19:57 [Note] /usr/local/libexec/mysqld: Shutdown complete > >Well, I didn't find "the manual" onboard, and looking at *a* manual at: >http://dev.mysql.com/doc/mysql/en/mysql-config-wizard-security.html >hasn't (thus far) unlocked the cryptic nature of the warning above. > >----------------------------------------------------------------- > >OK, option number two: > >/usr/local/bin/mysqld_safe > >Starts a mysql process but also steals the command prompt from that >screen window, so obviously although I have a running instance of mysql >this isn't the way to do it. >This is the result BTW >root 93521 0.0 0.1 1652 1260 p2 I+ 10:22AM 0:00.02 /bin/sh >/usr/local/bin/mysqld_safe >mysql 93538 0.0 2.6 55596 26704 p2 S+ 10:22AM 0:00.17 >/usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/ >(rest of the output on the previous line is buried at the end of the >screen which is annoying because I'd like to see what it is) > >Oh yes, there is a user and group mysql (the installer did that, not me) >but there is no password for user mysql yet...dunno if it's necessary, >but even if so, not done - yet. > >Guidance from those who have been there before would be greatly >appreciated. > >Regards, >-Colin >-- >Colin J. Raven >FreeBSD 5.3-RELEASE - http://www.FreeBSD.org - There IS only One - OS >Wed Jan 12 10:27:00 CET 2005 >10:27AM up 2 days, 13:56, 6 users, load averages: 0.06, 0.47, 0.65 > Did you added mysql_enable="YES" to /etc/rc.conf?