Date: Wed, 12 Jan 2005 10:37:51 +0100 From: Darksidex <humprhey@gmail.com> To: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: Trouble starting MySQL Message-ID: <41E4EFEF.9090400@gmail.com> In-Reply-To: <20050112101204.L1613@kenmore.kozy-kabin.nl> References: <20050112101204.L1613@kenmore.kozy-kabin.nl>
next in thread | previous in thread | raw e-mail | index | archive | help
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?
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41E4EFEF.9090400>