-   Linux - Software (
-   -   can't start mysql daemon (

IceGrill 07-29-2003 04:53 PM

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:

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?


neo77777 07-29-2003 05:14 PM

Ok try this, make sure there is mysql user on your system, the entry in my /etc/passwd looks like this
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 &

finegan 07-29-2003 05:46 PM

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.



IceGrill 07-29-2003 07:16 PM

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

All times are GMT -5. The time now is 03:57 AM.