Bug #53783 mysql_secure_installation should have usage information

Submitted: 19 May 2010 7:54 Modified: 9 Dec 2016 11:50
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:5.1.48, 5.4.4 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution, patch, script, usage

[19 May 2010 7:54] Daniël van Eeden
Description:
mysql_secure_installation does have options as show in bug #46842 but does not print usage information when called with the --help option.

How to repeat:
mysql_secure_installation --help

Expected: Usage information

Actual: It ignores the --help

Suggested fix:
--- mysql_secure_installation.sh.orig	2010-05-19 09:39:45.410764000 +0200
+++ mysql_secure_installation.sh	2010-05-19 09:49:14.219991000 +0200
@@ -200,8 +200,20 @@
     rm -f $config $command
 }
 
+usage() {
+    cat <<EOF
+Usage: $0 [OPTIONS]
+  -S, --socket=name   Socket file to use for connection.
+                      Buffer for TCP/IP and socket communication
+EOF
+    exit 1
+}
 
 # The actual script starts here
+if [ $1 = "--help" ]; then
+  usage
+fi
+
 
 prepare
 set_echo_compat
[19 May 2010 8:10] Valeriy Kravchuk
Thank you for the problem report and patch contributed.
[12 Jan 2014 17:39] Daniël van Eeden
This bug is fixed in MySQL 5.7
[10 Nov 2016 22:09] Oli Sennhauser
Not if my MySQL 5.7.16:

shell> mysql_secure_installation --help

Securing the MySQL server deployment.

Connecting to MySQL using a blank password.
The 'validate_password' plugin is installed on the server.
The subsequent steps will run with the existing configuration
of the plugin.
Please set the password for root here.

New password: 
...
[9 Dec 2016 11:50] Terje Røsten
Posted by developer:
 
Fixed by:

commit 2fb9344d2ab546402705e8d7203616d7487f5e35
Author: Vamsikrishna Bhagi <vamsikrishna.bhagi@oracle.com>
Date:   Tue Aug 13 21:47:28 2013 +0530

    WL#6441 Convert mysql_secure_installation script to C

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.063 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.