Bug #33922 -p option does not properly work in 5.0.45

• Submitted: 18 Jan 2008 15:59
• Modified: 19 Jan 2008 9:22
• Reporter: Vladimir Pasman
• Status: Not a Bug
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 5.0.45
• OS: MacOS
• CPU Architecture: Any

[18 Jan 2008 15:59] Vladimir Pasman

Description:
mysql --user=user --password=password works but mysql -u user -p password asks for a password again

How to repeat:
Added a user with a password to database. I believe I was asked if I wanted to save a conf file, but not sure where it is and what it looks like. 

Suggested fix:
make -p work the same as --password

[18 Jan 2008 16:30] Colin Charles

You might try mysql -uusername -pPassword

Note that there is no space between the -p and the password

If you do -p <password> (i.e. have a space between the p and the password), it now looks for a database name that is your password (not the intended operation, hence asking you for the password again)

[18 Jan 2008 17:08] Paul DuBois

See discussion of -p here:

http://dev.mysql.com/doc/refman/5.0/en/user-names.html

[19 Jan 2008 9:22] Valeriy Kravchuk

This is not a bug. Manual clearly says:

"There must be no space between the -p option and the following password value. See Section 5.4.4, “Connecting to the MySQL Server”."