mySQL Daemon Fails to start

[2marshall8]

Hello all,

I am currently running mysql on a SuSE 9.0 machine. here is the mysql version

Server version 4.0.15
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 23 min 0 sec

The problem I'm having is that whenever I start the service "rcmysql start" or directly from "/etc/init.d/mysql" it fails to start. the weird thing is that I can access the databases and login to mysql. Any idea on what I can try to correct this problem and get the daemon to run properly?

I've also done this:

" mysqladmin -u root -p ping "

and it's returned "mysqld is alive"

When I run the command " ps -e " I get three instances of mysqld and one of mysqld_safe. This safe instance worries me a little.


thanks
marshall

[Xnuiem]

Dont worry about the "safe". Most instances of MySQL running as servers use "safe" instead of MAX or DEV.

What it sounds like is happening, is that MySQL is already running, which would keep it from being started again.

If you can access the database, it is running, so I really dont think I would be concerned with this.

[gesf]

What i´ve read is that, there´s a bug in the current mysql init file: /etc/init.d/mysqld, witch causes it to appear to fail on startup when it actually did start up!

I´m not the right person to help you out in this problem, anyway, please read this next two articles.
If you make a search by your post title (E.g.: in google) , you´ll find some useful stuff.

Problems starting the MySQL server
Bug in /etc/init.d/mysqld

Cheers,
gesf

Thanks! You solved my problem as I was trying to get things togeter tonight. Just a permissions error, but your tip told me where to look. Hoorah! It runs!

-ermine