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?
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
./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.
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.
|All times are GMT -5. The time now is 07:31 AM.|