Problem Starting MySQL On Boot

siwelb · 03-24-2010, 08:28 AM

I have installed MySQL 5.0.27 on RHEL5 using the RPMs from the MySQL site (RHEL 4 version). I'm able to start MySQL manually by running the mysqld start script but I'm having trouble getting it to start when the server is rebooted. I've already run "chkconfig" and mysqld is on for levels 2, 3, 4 and 5. I was told that chkconfig takes care of symbolic links and everything so I didn't think I had to do anything manually with those. When I start the server and check processes I see the following:

Quote:

root 3494 2258 0 08:44 ? 00:00:00 /bin/sh /etc/rc5.d/S64mysqld start

After 30 seconds or so, this disappears and MySQL is not started. Any suggestions?

Thanks,
Brian

smoker · 03-24-2010, 12:43 PM

You could use yum to install the Red Hat mysql packages
I would uninstall the other one first

Code:

 rpm -q php-mysql mysql-server mysql

Whatever is listed from that command, remove using

Code:

 rpm -e php-mysql mysql-server mysql

then install and configure the red hat packages using the following commands :

Code:

yum install php-mysql mysql mysql-server
/sbin/chkconfig --levels 2345 mysqld on
/etc/init.d/mysqld start

mweed · 04-02-2010, 01:20 AM

I take it you are using the mysql community packages because you need mysql 5 and rhel4 only ships with mysql 4.

How exactly did you install the community packages? Were the RHEL mysql packages removed before using the community packages?

What error messages are being logged? console mysqld.log messages etc.

By mysqld start script do you mean /etc/init.d/mysqld? if so what does ls -l /etc/rc5.d/S64mysqld say its pointing to?

If there is a messup you could try:
chkconfig --del mysqld
chkconfig --add mysqld

-- EDIT --
If I recall the community edition uses mysql instead of mysqld for the name of the initscript. Are there both /etc/init.d/mysql and /etc/init.d/mysqld files?