Date: Wed, 12 Jan 2005 10:42:14 +0000 From: Matteo Santori <matteo@tilde.it> To: "Colin J. Raven" <colin@kenmore.kozy-kabin.nl> Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: Trouble starting MySQL Message-ID: <41E4FF06.3060200@tilde.it> 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
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" > > >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?41E4FF06.3060200>