password command-line option

[Jeff Dege]

I needed to be able to run mysql from a bash script, passing the password on the command-line, and I found the options inconsistent and confusing.

From the man page:

--user=user_name, -u user_name
--password[=password], -p[password]

These work:

-uuser_name -ppassword
-u user_name -ppassword

This does not:

-u user_name -p password

These work:

--user user_name --password=password
--user=user_name --password=password

This does not:

--user user_name --password password

I see no reason why -u should accept an optional space prior to the argument and -p should not, nor why --user should allow a space instead of an equals, and --password should not.