I see this warning in mysqld.err: Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line It would be nice if it wouldn't show up... :) mysql-4.0.15
I don't see why it is even creating the message. The only user setting is "user = mysql" in /etc/mysql/my.cnf it isn't set anywhere else!
verified as non-gentoo bug and sent upstream. http://bugs.mysql.com/bug.php?id=1842
Well, from the mySQL bug site, I don't think they are going to do anything about it. A little search revealed that the /usr/bin/mysqld_safe does indeed set the --user flag. The parse_arguments() function near the top does receive the user flag at some point, but I've not yet been able to figure out when exactly. In several places in that script, it appear to say that the info is fetched from the my.cnf file. On line 106, the comment says: "Get first arguments from the my.cnf file, groups [mysqld] and [mysqld_safe]" Additionally, line 96 (of mysqld_safe) is this: user=mysql I've commented out the "user" line in my.cnf and the server starts fine, without the warning. Attempts to prevent mysqld_safe from setting the user resulted in mySQL not starting at all.