Trouble starting MySQL
Darksidex
humprhey at gmail.com
Wed Jan 12 01:37:52 PST 2005
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?
More information about the freebsd-questions
mailing list