Bug #62752 mysqld --verbose --help ends with error
Submitted: 15 Oct 2011 17:32 Modified: 13 Nov 2011 17:48
Reporter: Valentine Gostev Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.5.16, 5.1.60 OS:Linux (CentOS 5.7 x86_64)
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D3 (Medium)

[15 Oct 2011 17:32] Valentine Gostev
Description:
./mysqld --help advises to use "--verbose --help" for more detailed output, but it finishes with error if we do not specify --basedir option:

# ./mysql-5.5.16-linux2.6-x86_64/bin/mysqld  --verbose --help 1>/dev/null
111015 21:31:16 [ERROR] Can't find messagefile '/usr/local/mysql/share/errmsg.sys'
111015 21:31:16 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

111015 21:31:16 [ERROR] Aborting

# echo $?
1

How to repeat:
./mysqld --verbose --help 1>/dev/null
[13 Nov 2011 17:48] Valeriy Kravchuk
Indeed, this is easy to repeat on Mac OS X also:

macbook-pro:5.1 openxs$ sudo libexec/mysqld --verbose --help >/dev/null
111113 19:44:17 [Warning] Setting lower_case_table_names=2 because file system for /Users/openxs/dbs/5.1/var/ is case insensitive
111113 19:44:17 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

111113 19:44:17 [ERROR] Aborting

While for non-root user there is no problem:

macbook-pro:5.1 openxs$ libexec/mysqld --verbose --help >/dev/null
111113 19:44:48 [Warning] Setting lower_case_table_names=2 because file system for /Users/openxs/dbs/5.1/var/ is case insensitive
111113 19:44:48 [Note] Plugin 'FEDERATED' is disabled.
111113 19:44:48 [Note] Plugin 'ndbcluster' is disabled.

This is probably related to/a duplicate of Bug #63187 I've recently verified.
[31 Jul 2014 13:29] Daniƫl van Eeden
Related: Bug #71599