When connecting using the mysql cli, why is there no space between -p and the password? e.g. -ppassword

Question

mysql -hhost -uuser -ppassword

Is there a rationale behind why there's no need for spaces? In fact, it wouldn't work unless there is no space.

Because that's the way they wrote it. – user207421 Feb 04 '18 at 00:38 — user207421, Feb 04 '18 at 00:38

score 1 · Answer 1 · answered Feb 04 '18 at 00:41

1

Found my answer:

https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html

It's just the way they wrote it.

answered Feb 04 '18 at 00:41

geoyws

3,326
3
35
47

score 0 · Answer 2 · answered Nov 23 '20 at 21:22

If you use a command like

mysql -h hostname -u username -p xxx

the command is ambiguous. It could mean that xxx is the password and no database was specified, or it could mean that xxx is the database and no password was specified (in which case mysql prompts for a password).

They chose the second interpretation. But if you use -pxxx then xxx can only be interpreted as the password.

When connecting using the mysql cli, why is there no space between -p and the password? e.g. -ppassword

2 Answers2