Trouble starting MySQL

[Matteo Santori]

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 at freebsd.org mailing list
>http://lists.freebsd.org/mailman/listinfo/freebsd-questions
>To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"
>
>  
>