即使在命令行选项中告诉它密码,mysqldump也要求input密码

我正在使用以下命令:

mysqldump -alv -h 123.123.123.123 --password=P@ssw0rd --user=UsernameHere --add-drop-table -p DatabaseSchemaName > dump.sql 

然后它要我input密码。 在命令中指定密码时,我是否做错了?

我input的密码绝对是正确的密码。

男人mysqldump:

 --password[=password], -p[password] The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, you are prompted for one. Specifying a password on the command line should be considered insecure. See Section 6.6, "Keeping Your Password Secure". 

你有两个密码参数:

mysqldump -alv -h 123.123.123.123 –password = P @ ssw0rd –user = UsernameHere –add-drop-table -p DatabaseSchemaName> dump.sql

删除最后一个参数,它应该正常工作。