mysql startup

eyewittness · 07-22-2005, 04:06 PM

I like to start mysql at boot time. So i putted this command in my /etc/rc.d/rc.local :
/usr/local/mysql/libexec/mysqld --skip-innodb -user=mysql &

well i got some errors while rebooting so probably that command is incorrect although the mysql user exists.
Maybe someone can tell me how i can run that mysql command as user mysql. I use slackware 7.1

rjlee · 07-23-2005, 09:04 AM

Quote:

Originally posted by eyewittness
/usr/local/mysql/libexec/mysqld --skip-innodb -user=mysql &

mysqld doesn't have a -user parameter. You do, however want to start it as the user mysql:

Code:

su mysql -c '/usr/local/mysql/libexec/mysqld --skip-innodb'

There are various other options that you might need, depending on your setup, such as your base directory and location of your data directory. To see these, run:

Code:

/usr/local/mysql/libexec/mysqld --help | less

You may also need to edit /etc/my.cnf

See http://dev.mysql.com/doc/mysql/en/index.html for more details.