On Friday 20 December 2002 8:55 am, Linux World 999 wrote:
Using SuSE 8.1, MySql database server has been installed. The install_db script runs fine. However, Mysql does not startup when booting. In the runlevel editor, MySQL service hangs if it is started. The kill command has to be used to stop mysql return linux back to a normal condition.
Even if you install SuSE's specific RPM [from their CD/DVD, for instance] it does indeed hang when you try to actually "start" it via the [graphical] runlevel editor -- you should simply set the "start for mode..." settings for 3 or 5 [usually both, actually] and perhaps even mode 2 [though rarely used...] This basically adds link files to the /etc/rcX.d directories of the form S##mysql and K##mysql to start and stop respectively when you change runlevels [i.e., "at the next reboot", for you windows types ;) or if you want to get away from that, learn the [tel]init command...]
To manually start MySql, the command "safe_mysqld --user=root &" works but the standard command "safe_mysqld --user=mysql &" will not start mysql and exists with an error.
Also, if you install w/SuSE's files, there should exist an "rcmysql" link file [I think under /sbin, but basically only in a directory found in "root"'s path -- normal users don't "see" the rc.... commands] these also link to the /etc/rd.d startup files, so the command rcmysql start should "manually" start the service(s). Likewise, the commands rcmysql status rcmysql stop show whether the service is "running" and stop it respectively.