cannot start mysql on redhat through "service" command

Hello,
I'v installed mysql 5.0
(MySQL-server-standard-5.0.27-0.rhel4.i386.rpm) on RedHat AS4.
When I start mysql through command line (i.e. /usr/bin/mysqld_safe
--datadir=/var/lib/mysql --pid-file=/tmp/mysql.pid & ), everything is
ok. But when I use "service mysql start" command launch it, mysql just
quit silently.

The log file report is:

061031 11:31:35 mysqld started
061031 11:31:35 mysqld ended

And the command line report:

Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /tmp/mysql.pid
061031 12:01:18 mysqld ended

What can I do to find the problems?

Re: cannot start mysql on redhat through "service" command

i think this may be a redhat issue; however, a lot of times when
services do not start properly it's either a path or permissions issue!!!

Chris Song wrote:
> Hello,
> I'v installed mysql 5.0
> (MySQL-server-standard-5.0.27-0.rhel4.i386.rpm) on RedHat AS4.
> When I start mysql through command line (i.e. /usr/bin/mysqld_safe
> --datadir=/var/lib/mysql --pid-file=/tmp/mysql.pid & ), everything is
> ok. But when I use "service mysql start" command launch it, mysql just
> quit silently.
>
> The log file report is:
>
> 061031 11:31:35 mysqld started
> 061031 11:31:35 mysqld ended
>
> And the command line report:
>
> Starting mysqld daemon with databases from /var/lib/mysql
> STOPPING server from pid file /tmp/mysql.pid
> 061031 12:01:18 mysqld ended
>
> What can I do to find the problems?
>

Re: cannot start mysql on redhat through "service" command

On Mon, 30 Oct 2006 20:02:42 -0800, Chris Song wrote:

> Hello,
> I'v installed mysql 5.0
> (MySQL-server-standard-5.0.27-0.rhel4.i386.rpm) on RedHat AS4.
> When I start mysql through command line (i.e. /usr/bin/mysqld_safe
> --datadir=/var/lib/mysql --pid-file=/tmp/mysql.pid & ), everything is
> ok. But when I use "service mysql start" command launch it, mysql just
> quit silently.
>
> The log file report is:
>
> 061031 11:31:35 mysqld started
> 061031 11:31:35 mysqld ended
>
> And the command line report:
>
> Starting mysqld daemon with databases from /var/lib/mysql STOPPING
> server from pid file /tmp/mysql.pid 061031 12:01:18 mysqld ended
>
> What can I do to find the problems?

Look for the .err file in the mysql data dir.
The file should be /var/lib/mysql/{machine name}.err and should show you
exactly what the problem is.

I don't know why this vital info isn't dumped to the console when you
start from the command line.
Thomas Bartkus