Click here to get back home

cannot start mysql on redhat through "service" command
 Home | NewsGroups | Search | About
Login Password
Register Now!
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
cannot start mysql on redhat through "service" command Chris Song 10-30-2006
Posted by Chris Song on October 30, 2006, 11:02 pm
Please log in for more thread options
 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?


Posted by lark on October 31, 2006, 9:31 am
Please log in for more thread options
 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?
>

Posted by Thomas Bartkus on October 31, 2006, 9:51 pm
Please log in for more thread options
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






Similar ThreadsPosted
I can not install mysql 4.1 on redhat 9. August 30, 2005, 8:35 pm
Problem installing mysql-administrator on Redhat January 18, 2006, 9:37 am
Re-setting mysql as a service September 28, 2005, 8:45 am
Unable to run mysql service on windows98se October 27, 2006, 2:48 pm
Where to get My SQL for Redhat 9 June 4, 2005, 5:10 pm
mysql will not start with LDAP February 19, 2006, 6:53 pm
Mysql refusing to start November 24, 2006, 12:58 am
periodically start and stop mysql October 31, 2006, 9:55 am
how to connect mysql5 using c++ in redhat-linux February 14, 2007, 8:04 am
mySQL command questing. November 13, 2005, 8:38 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap