From owner-freebsd-questions@FreeBSD.ORG Wed Jan 12 09:30:28 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 DE14916A4CE for ; Wed, 12 Jan 2005 09:30:28 +0000 (GMT) Received: from t-x.dignus.nl (t-x.dignus.nl [83.219.88.50]) by mx1.FreeBSD.org (Postfix) with ESMTP id 42C4643D31 for ; Wed, 12 Jan 2005 09:30:28 +0000 (GMT) (envelope-from colin@kenmore.kozy-kabin.nl) Received: from localhost (localhost.dignus.nl [127.0.0.1]) by t-x.dignus.nl (Safehouse) with ESMTP id D91582841C for ; Wed, 12 Jan 2005 10:30:42 +0100 (CET) Received: from kenmore.kozy-kabin.nl (cjr-home [62.251.72.148]) by t-x.dignus.nl (Safehouse) with ESMTP id 1252E2841A for ; Wed, 12 Jan 2005 10:30:38 +0100 (CET) Received: from kenmore.kozy-kabin.nl (localhost.kozy-kabin.nl [127.0.0.1]) by kenmore.kozy-kabin.nl (Postfix) with ESMTP id EF8A561BD for ; Wed, 12 Jan 2005 10:30:20 +0100 (CET) Received: from localhost (colin@localhost)j0C9UK1h061636 for ; Wed, 12 Jan 2005 10:30:20 +0100 (CET) (envelope-from colin@kenmore.kozy-kabin.nl) Date: Wed, 12 Jan 2005 10:30:20 +0100 From: "Colin J. Raven" To: FreeBSD Questions Message-ID: <20050112101204.L1613@kenmore.kozy-kabin.nl> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by RemSPAMd at ph230.plushosting.nl Subject: 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:30:29 -0000 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