MySQL Bugs: #71599: Unexpected log output for mysqld --help --verbose

Bug #71599	Unexpected log output for mysqld --help --verbose
Submitted:	6 Feb 2014 7:48	Modified:	31 Jul 2014 13:28
Reporter:	Daniël van Eeden (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Logging	Severity:	S3 (Non-critical)
Version:	5.6.15, 5.6.19	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
"mysqld --help --verbose" should not give unexpeced errors.

This should have been fixed in 5.6.12: Bug #68578

How to repeat:
# mysqld --verbose --help > /dev/null
2014-02-06 08:36:52 20107 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2014-02-06 08:36:52 20107 [ERROR] Aborting

2014-02-06 08:36:52 20107 [Note] Binlog end

$ /usr/sbin/mysqld --help --verbose > /dev/null
2014-02-06 08:44:03 20142 [Warning] Can't create test file /var/lib/mysql/xxxxxxxxxxxx.lower-test
2014-02-06 08:44:03 20142 [Warning] Can't create test file /var/lib/mysql/xxxxxxxxxxxxx.lower-test
2014-02-06 08:44:03 20142 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2014-02-06 08:44:03 20142 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)

2014-02-06 08:44:03 20142 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13 - Permission denied)
2014-02-06 08:44:03 20142 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2014-02-06 08:44:03 20142 [Note] Binlog end
2014-02-06 08:44:03 20142 [Note] Shutting down plugin 'CSV'
2014-02-06 08:44:03 20142 [Note] Shutting down plugin 'MyISAM'

Suggested fix:
Don't emit a warning for running as root with the "--help --verbose" options.

Try to limit warnings/errors to useful errors. (e.g. suggesting to run mysql_upgrade to create ./mysql/plugin.frm is not helpfull)

Hello Daniel,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh

This seems to be related to Bug #62752

Still happens with 5.6.19

D:\mysql>bin\mysqld.exe --help --verbose > NUL
2014-07-31 15:25:18 10596 [Note] Plugin 'FEDERATED' is disabled.
2014-07-31 15:25:19 10596 [Note] Binlog end
2014-07-31 15:25:19 10596 [Note] Shutting down plugin 'MyISAM'
2014-07-31 15:25:19 10596 [Note] Shutting down plugin 'CSV'

D:\mysql>bin\mysqld.exe --version
bin\mysqld.exe  Ver 5.6.19 for Win64 on x86_64 (MySQL Community Server (GPL))