MySQL Backup using mysqldump Specifying username and password
Example
> mysqldump -u username -p [other options]
Enter password:
If you need to specify the password on the command line (e.g. in a script), you can add it after the -p option without a space:
> mysqldump -u username -ppassword [other options]
If you password contains spaces or special characters, remember to use escaping depending on your shell / system.
Optionally the extended form is:
> mysqldump --user=username --password=password [other options]
(Explicity specifying the password on the commandline is Not Recommended due to security concerns.)
