cannot start mysql on redhat through "service" command

[Chris Song]

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?

[lark]

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?

[Thomas Bartkus]

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