How to add mysqld_safe --user=mysql & in /etc/rc.d/rc.local

Han_Nguyen · 07-06-2007, 11:49 PM

Hi all,

I just started to learn about Linux and first time try to install mysql on my Mandrake machine. Could someone please show me what is the syntax to add ../bin/mysqld_safe --user=mysql & into my system start up script rc.local so mysql will start every time when my computer boot up. Any help would be greatly appreciated.

reddazz · 07-07-2007, 04:50 PM

Hi and welcome to LQ. If you compiled mysql from source, then the right way to do it is to copy a file called mysql.server (from the mysql source tarball or your mysql installation) to /etc/init.d, rename it to mysql and then do

Code:

#chkconfig --add mysql
#chkconfig mysql on

If you installed mysql from your distributions packages, then all you need to do is

Code:

#chkconfig mysql on

In both cases mysql will start automatically each time you boot your machine.

Han_Nguyen · 07-08-2007, 01:51 PM

Reddazz,

Thank you for your response to my post. I am installing mysql from source. I have not able to find mysql.server from the source tarball directory or /usr/local/bin. I am installing mysql-5.0.22, could mysql.server file be located somewhere else?

Thanks again,

reddazz · 07-09-2007, 03:39 PM

Sorry for the late reply. In the mysql 5.x tarball, there is a folder called support-files, copy mysql.server.sh to /etc/init.d and rename it to mysql.

Han_Nguyen · 07-10-2007, 12:04 AM

Reddazz,

I have copied the file over and did the chkconfig commands. I got 4-5 responses "Warning: netfs is needed by mysql in runlevel 2" each time. Could you advice what does it mean. I am seeing a netfs file in the same directory. Thanks again for your help.

reddazz · 07-10-2007, 12:15 AM

I've been looking at the Mandriva developer site and it seems like that error happens when you have not added the mysql user and group to the system. Also maybe you need to enable netfs which you can do using "chkconfig netfs on".

Han_Nguyen · 07-10-2007, 08:47 PM

Reddazz,

After do the chkconfig netfs on, I don't get those messages anymore. However, mysql still is not start up automatically when the machine boot up. I still have to start it manually. You mentioned about add user and group to system, how can I do that. Again, many thanks for your help.

reddazz · 07-11-2007, 03:19 AM

You use the useradd and groupadd commands. If mysql starts manually, then the problem does not seem to be related to groups. What is the output of doing

Code:

#chkconfig --list | grep -i mysql

Han_Nguyen · 07-14-2007, 12:09 AM

Redazz,

Sorry, I was out the last couple of days. This is the result when I execute the command:

[root@localhost tmp]# chkconfig --list | grep -i mysql
mysql 0

ff 1

ff 2

n 3

n 4

n 5

n 6

ff
[root@localhost tmp]#

Please help

reddazz · 07-14-2007, 02:42 AM

From the results, it seems like it is set to startup at boot time. What happens when you do

Code:

#service mysql start

Another option is to add the commands to start mysql in /etc/rc.d/rc.local.

Han_Nguyen · 07-15-2007, 11:15 PM

Reddazz,

Here is the results bounced back when I type in that command:

[root@localhost mysql]# service mysql start
/etc/init.d/mysql: line 220: my_print_defaults: command not found
/etc/init.d/mysql: line 223: my_print_defaults: command not found
/etc/init.d/mysql: line 230: @HOSTNAME@: command not found
/etc/init.d/mysql: line 239: @HOSTNAME@: command not found
/etc/init.d/mysql: line 248: cd: @prefix@: No such file or directory
[root@localhost mysql]#

BTW, what is the syntax to add start mysql in /etc/rc.d/rc.local?

Many many thanks!

reddazz · 07-16-2007, 06:40 PM

Try adding /usr/local/mysql/bin or whatever directory contains your mysql binaries to your PATH.