From owner-freebsd-questions@FreeBSD.ORG Wed Jan 12 09:42:48 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 64D5816A4CE for ; Wed, 12 Jan 2005 09:42:48 +0000 (GMT) Received: from web-17.seeweb.it (web-17.seeweb.it [212.25.166.1]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1F12C43D45 for ; Wed, 12 Jan 2005 09:42:47 +0000 (GMT) (envelope-from matteo@tilde.it) Received: from [80.181.46.161] (host161-46.pool80181.interbusiness.it [80.181.46.161]) by web-17.seeweb.it (8.11.6p2/8.9.3) with ESMTP id j0C9QRK06004; Wed, 12 Jan 2005 10:26:27 +0100 Message-ID: <41E4FF06.3060200@tilde.it> Date: Wed, 12 Jan 2005 10:42:14 +0000 From: Matteo Santori User-Agent: Mozilla Thunderbird 0.9 (X11/20041204) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Colin J. Raven" References: <20050112101204.L1613@kenmore.kozy-kabin.nl> In-Reply-To: <20050112101204.L1613@kenmore.kozy-kabin.nl> Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit cc: FreeBSD Questions 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:42:48 -0000 you SHOULD set a password root but that's not the problem releated with this error. (mysqladmin -u root password 'yourpassword') it looks like your mysqld is not started trought.. mysqld_safe --user=mysql your should check this. hope this help, M 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 > >_______________________________________________ >freebsd-questions@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-questions >To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org" > > >