我正在使用以下命令:
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
删除最后一个参数,它应该正常工作。