I'm running a FreedBSD server with mysql 4.1. When I start mysqld via the command:

# /usr/local/bin/safe_mysqld --user=mysql

it starts the mysql db (I know because the websites are running off of it) but does not return to a prompt, it will let me type but will not respond unless I restart the system. Any ideas on how to resovle this.

Thanks,

I take it you're doing maintenance. Either that or BSD doesn't have an init system?

How about:

/usr/local/bin/safe_mysqld --user=mysql < /dev/null > /dev/null 2> /dev/null &

Thanks,

I'm not doing maintenance but I just installed mysql and never configured it to run on init.

I will try that and let you/others know, will have to wait until tonight when my server traffic is less.

Thanks again.

you should edit the /etc/rc.conf and place mysql_enable="YES" in that file, then run /usr/local/etc/rc.d/mysql-server.sh start

I had already added mysql_enable="YES" in /etc/rc.conf but when a enter /usr/local/etc/rc.d/mysql-server.sh start it says "command not found"

By the way there is no file mysql-server.sh but there is mysql-server and substituting that for mysql-server.sh does not work either ("command not found")

Any ideas? All the help is greatly appreciated.

just check the directory listing inside of /usr/local/etc/rc.d and execute the startup script relating to mysql, unless of course you did not install it from ports, if you compiled it by downloading the sources, i don't think the rc script is included.