Bug #68578 Unexpected log output for mysqld --help --verbose
Submitted: 5 Mar 2013 21:01 Modified: 22 Mar 2013 1:27
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Errors Severity:S3 (Non-critical)
Version:5.6.10 OS:Any
Assigned to: CPU Architecture:Any

[5 Mar 2013 21:01] Daniël van Eeden
The 'mysqld --help' and 'mysqld --verbose --help' commands do output logging and the expected help output.

5.6.10/bin$ ./mysqld --help > /dev/null
2013-03-05 21:58:14 0 [Note] Binlog end

5.6.10/bin$ ./mysqld --help --verbose > output.stdout 2> output.stderr
5.6.10/bin$ ls -s1 output*
 12 output.stderr
124 output.stdout
5.6.10/bin$ cat output.stderr 
2013-03-05 21:54:19 16105 [ERROR] Can't find messagefile '/usr/share/errmsg.sys'
2013-03-05 21:54:19 16105 [Warning] Can't create test file /var/lib/mysql/node1.lower-test
2013-03-05 21:54:19 16105 [Warning] Can't create test file /var/lib/mysql/node1.lower-test
./mysqld: Can't change dir to '/var/lib/mysql/' (Errcode: 13 - Permission denied)
2013-03-05 21:54:19 16105 [Warning] One can only use the --user switch if running as root

2013-03-05 21:54:19 16105 [Note] Plugin 'FEDERATED' is disabled.
./mysqld: Unknown error 1017
2013-03-05 21:54:19 16105 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2013-03-05 21:54:19 16105 [Note] Binlog end
2013-03-05 21:54:19 16105 [Note] Shutting down plugin 'CSV'
2013-03-05 21:54:19 16105 [Note] Shutting down plugin 'MyISAM'
5.6.10/bin$ head output.stdout 
./mysqld  Ver 5.6.10 for linux-glibc2.5 on x86_64 (MySQL Community Server (GPL))
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Starts the MySQL database server.

Usage: ./mysqld [OPTIONS]

How to repeat:
mysqld --help --verbose > /dev/null

Suggested fix:
Make sure the help commands will only output the help info and do not do anything else. With the --help option mysqld must not create any files and it should not output any logging.
[6 Mar 2013 5:14] Erlend Dahl
Thank you for the bug report. Verified as described on 5.6. 5.5 doesn't seem to have this problem.
[22 Mar 2013 1:27] Paul DuBois
Noted in 5.6.12, 5.7.2 changelogs.

mysqld --help and mysqld --verbose --help did unnecessary logging.
[1 Apr 2013 12:38] MySQL Verification Team
bug #68823 was a duplicate