Hi all,

I have installed MySQL onto my RedHat 8 machine. I would like the mysql daemon (mysqld) to automatically run at startup. In /etc/rc.d/rc3.d, what wouls need to go there? What kind of file? I know that all the "startup" files begin with "S" and in /etc/rc.d/rc6.d and /etc/rc.d/rc0.d all the stop daemon files are "K" files. What would I name the startup file for MySQL, and what would the file contain? Right now, I start the MySQL daemon manually with the command:

"mysql.server start" from anywhere in the system.

Oh, and in the startup directiries, what do all the numbers mean, like S35httpd and S45named. What do the 35 and 45 mean? Each startup file has a differnet number, but some are shared! Thanks guys!

Chris

Hi cjwsb,

to start all service here the command,

with 'chkconfig ' command you can add,remove,and change services;list

eg:
#/sbin/chkconfig --list sendmail
sendmail 0:off 1:off 2:on 3:on 4:on 5:on 6:off

that mean sendmail confgiured to all run level.
and if you want to turn off for runlevel 4,then

# /sbin/chkconfig --level 4 sendmail off

same substituting with on and off.

with chkconfig can aslo add or delete services with the --add and --del switchs.

for more info see man pages

Hitesh

So, if I want it to start at run level 3 and stop at run levels 0 and 6, the commands would be this?

# /sbin/chkconfig --level 3 mysql.server on
# /sbin/chkconfig --level 0 mysql.server off
# /sbin/chkconfig --level 6 mysql.server off

I can see how your sendmail example would work because RH understands that "sendmail" is a service, but why would this work on my machine? Could you elaborate please?

Thanks,

Chris

You can use:

chkconfig --list

to see all the available services. For mysql the daemon is mysqld so it would be:

chkconfig --level 3 mysqld on

Nope, sorry. That didn't work. I tried all of these:

chkconfig --level 3 /usr/sbin/mysqld on
chkconfig --level 3 /usr/sbin/mysql.server on
chkconfig --level 3 mysql.server on
chkconfig --level 3 mysqld on

None worked. I would get:

error reading information on service whatever: No such file or directory

Like I said, my executable file to start, stop, and restart is "mysql.server" and it is located in /usr/sbin. How can I automatically run that at startup?

Chris

Does:

chkconfig --list | grep mysql

return anything?

No, it did not. Hmmmmmmm

Chris

Check the directory /etc/init.d for a mysql startup file if you installed it with an rpm it should be there. If you instaleld it by source then mysql comes with a startup file called mysql.server or at least it used to copy that file to /etc/init.d then try the chkconfig command again.

if you could always enter the start command in /etc/rc.d/rc.local
as well.

You can also create symbolic links in your respective directories.

for example in my start up dir i have S78mysqld -> ../init.d/mysqld

good luck

JSTU,

I installed from source and that is the startup file (mysql.server). I will try what you suggest. Thanks!

Chris

Or to make it simple, you could install Webmin and there is the option in there that you can have mysql to start at bootup.

Although, you wouldn't learn that much. But it will do the trick.

regards, Kenny

JSTU,

What you suggested did it! Thanks!

Chris

use [B]ntsysv[\B]