can't start mysql daemon
 

I'm running Red Hat 9

I downloaded the binaries for mysql 4.0.14 and installed them to /usr/local/mysql

The mysql client works fine, and at one point i had both the server and client running and actually working, however now i cannot start the mysql daemon.

When the current directory is set to /usr/local/mysql/bin i try typing:
./safe_mysqld

the console reponds with:
Starting mysqld daemon with databases from /var/lib/mysql
##### HH:MM:SS mysqld ended

the #'s are the pid and HMS is a time stamp.

can anyone tell my why my mysql server stops running as soon as i start it?

thx

Ok try this, make sure there is mysql user on your system, the entry in my /etc/passwd looks like this
mysql:x:27:27:MySQL:/var/lib/mysql:
check that /var/lib/mysql is owned by mysql user
and start it up as root with
cd /usr/local/mysql
./bin/safe_mysqld --user=mysql &

If the whole thing is installed in /usr/local, then check for the error log file in /usr/local/var/lib/mysql/$HOSTNAME.err

There's also a options you can add to my.cnf to crank up the chatiness of that error log.

Cheers,

Finegan

YES!!! Thanks for the help! I followed both your suggestions and using the error log file fixed the problem. There were mysqld process that were running and not responding.

Apparently, the mysqld daemon has decided to use a socket that the mysql client and mysqladmin aren't using...grr.

thx again