Re: [Devil-Linux-discuss] 1.3.4 starting mysql

[Bruce S. <bw...@ar...>]

> I'll take a look at mysql to see if it solves that problem too.

No, that didn't solve the problem, but I did figure out the cause.

For some reason "--user=mysql" is not working on the command line in the
init.d script during boot.

/var/mysql/dns2.err:
========================================================================
080409 10:38:44 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
080409 10:38:44 [ERROR] Aborting
========================================================================

If I add "user = mysql" in /etc/my.cnf (under the [mysqld] section),
then mysql starts fine upon boot.  Very weird ...

Since we are copying the my.cnf file from the mysql tmp source:

  cp $TMPDIR/usr/share/mysql/my-small.cnf $ETCDIR/etc/my.cnf

I'm not sure the best way to add the line to the file, or IF we should
add it to the file (since it overrides the config parameters).  Heiko?

I've also tried starting mysqld_safe with "su - mysql -c ..." in the
init.d script, but I haven't gotten that to work either (parameters are
not passing to the script).  But then again, hardcoding the user id in
the init.d script overrides the MYSQL_PARM --user=mysql parameter
in /etc/sysconfig/config.

 - BS