Debian run MySQL on Startup

baandar · 09-01-2004, 12:13 AM

Hi, this seems to be a common problem without a common answer: how do I get mysql to run automatically on startup on Debian? I think I have to start mysqld, so I have tried adding a link to this in etc/rc2.d/ called S20myql. However, that is apparently not working.

They only way I can start MySQL is to log in with SSH and run mysqld (which freezes the computer), close SSH, and login again, then it is running. Thanks very much.

linux_terror · 09-01-2004, 04:19 AM

are you running in runlevel 2?

Default runlevel. The runlevels used by RHS are:
# 0 - halt (Do NOT set initdefault to this)
# 1 - Single user mode
# 2 - Multiuser, without NFS (The same as 3, if you do not have networking)
# 3 - Full multiuser mode
# 4 - unused
# 5 - X11
# 6 - reboot (Do NOT set initdefault to this)

most systems boot to 3 or 5 although i am not that familiar with debian....

If you arent then you need to put your init-script in /etc/rc3.d/ or /etc/rc5.d/

As for ssh locking up, mysql probably is running in daemon mode so you would need to tell it to fork into the background to get your command line back on a manual start. I can't remember exactly but I "think" this is achieved with a && at the end of the line...somebody please correct me if im wrong...

hope this helps.

linux_terror

HappyTux · 09-01-2004, 06:47 PM

Quote:

Originally posted by baandar
Hi, this seems to be a common problem without a common answer: how do I get mysql to run automatically on startup on Debian? I think I have to start mysqld, so I have tried adding a link to this in etc/rc2.d/ called S20myql. However, that is apparently not working.

They only way I can start MySQL is to log in with SSH and run mysqld (which freezes the computer), close SSH, and login again, then it is running. Thanks very much.

If it is a common problem I have never seen it here. How did you install MYSQL anyways? You should not have to be setting up any links that is already taken care of in the installation and configuration of the packages.

Code:

[HappyTux:/home/stephen]# ll /etc/rc2.d/
total 0
lrwxrwxrwx  1 root root 17 2004-03-30 22:40 K11anacron -> ../init.d/anacron
lrwxrwxrwx  1 root root 18 2004-03-30 22:40 S10sysklogd -> ../init.d/sysklogd
lrwxrwxrwx  1 root root 15 2004-03-30 22:40 S11klogd -> ../init.d/klogd
lrwxrwxrwx  1 root root 22 2004-03-30 22:40 S19spamassassin -> ../init.d/spamassassin
lrwxrwxrwx  1 root root 14 2004-06-24 22:25 S20alsa -> ../init.d/alsa
lrwxrwxrwx  1 root root 14 2004-03-30 22:40 S20apmd -> ../init.d/apmd
lrwxrwxrwx  1 root root 16 2004-03-30 22:40 S20autofs -> ../init.d/autofs
lrwxrwxrwx  1 root root 16 2004-03-30 22:40 S20cupsys -> ../init.d/cupsys
lrwxrwxrwx  1 root root 15 2004-03-30 22:40 S20dictd -> ../init.d/dictd
lrwxrwxrwx  1 root root 14 2004-03-30 22:40 S20exim -> ../init.d/exim
lrwxrwxrwx  1 root root 17 2004-03-30 22:40 S20hddtemp -> ../init.d/hddtemp
lrwxrwxrwx  1 root root 15 2004-03-30 22:40 S20inetd -> ../init.d/inetd
lrwxrwxrwx  1 root root 13 2004-03-30 22:40 S20lpd -> ../init.d/lpd
lrwxrwxrwx  1 root root 17 2004-03-30 22:40 S20makedev -> ../init.d/makedev
lrwxrwxrwx  1 root root 15 2004-07-21 02:29 S20mysql -> ../init.d/mysql
lrwxrwxrwx  1 root root 23 2004-03-30 22:40 S20smartmontools -> ../init.d/smartmontools
lrwxrwxrwx  1 root root 13 2004-03-30 22:40 S20ssh -> ../init.d/ssh
lrwxrwxrwx  1 root root 13 2004-03-30 22:40 S20xfs -> ../init.d/xfs
lrwxrwxrwx  1 root root 17 2004-03-30 22:40 S89anacron -> ../init.d/anacron
lrwxrwxrwx  1 root root 13 2004-03-30 22:40 S89atd -> ../init.d/atd
lrwxrwxrwx  1 root root 14 2004-03-30 22:40 S89cron -> ../init.d/cron
lrwxrwxrwx  1 root root 16 2004-06-12 23:03 S91apache -> ../init.d/apache
lrwxrwxrwx  1 root root 13 2004-03-30 22:40 S99kdm -> ../init.d/kdm
lrwxrwxrwx  1 root root 19 2004-03-30 22:40 S99rmnologin -> ../init.d/rmnologin
lrwxrwxrwx  1 root root 23 2004-03-30 22:40 S99stop-bootlogd -> ../init.d/stop-bootlogd

It looks like you are trying creating the correct link you may want to use either update-rc.d mysql defaults or ln -sf /etc/init.d/mysql /etc/rc2.d/S20mysql.

baandar · 09-02-2004, 01:45 AM

Hi again,
Thanks to you both for you help, level 2 is my default run level. Installing with apt-get I had the option for auto load on boot, but wanting to learn more about linux and being slightly foolish I disabled this option. Will try suggested commands an post again tomorrow.