MySQL Bugs: #44592: mysqladmin -p does not work properly, still ask for password

Bug #44592	mysqladmin -p does not work properly, still ask for password
Submitted:	1 May 2009 2:26	Modified:	6 May 2009 23:39
Reporter:	mars king	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Windows (xp sp3)
Assigned to:		CPU Architecture:	Any
Tags:	mysqladmin

Description:
mysqladmin -u root -p <passwd> shutdown
does not work properly, still prompt to ask for a password. While
mysqladmin -u root --password=<passwd> shutdown
works.

How to repeat:
type the command in Command window.

Thank you for the bug report. I couldn't repeat:

c:\dbs>5.1\bin\mysqladmin -umiguel -pmiguel --port=3510 shutdown

c:\dbs>

notice above that according the intructions in the Manual when connecting with a server with client programs at:

http://dev.mysql.com/doc/refman/5.1-maria/en/connecting.html

" For password options, the password value is optional:

    *

      If you use a -p or --password option and specify the password value,  there must be no space between -p or --password= and the password following it."

False alarm. I did put space between -p and <password>.

However, I really suggest we document this in the mysaladmin command line help rather than burried in the Reference Manual->4. MySQL Programs->4.2. Using MySQL Programs->4.2.2. Connecting to the MySQL Server. It is a bit counterintuitive to find and startup and shutdown will be the first several tasks when someone starts with MySQL. So we should document this when we type mysqladmin:

 -p, --password[=name]
                     Password to use when connecting to server. If password is
                     not given it's asked from the tty. [There must be no space between -p or --password= and the password following it]