Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 12 Jan 2005 10:30:20 +0100
From:      "Colin J. Raven" <colin@kenmore.kozy-kabin.nl>
To:        FreeBSD Questions <freebsd-questions@freebsd.org>
Subject:   Trouble starting MySQL
Message-ID:  <20050112101204.L1613@kenmore.kozy-kabin.nl>

next in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050112101204.L1613>