7.5 Specifying MySQL Connection Settings for mysqlbackup

When mysqlbackup creates a backup, it sends SQL commands to MySQL server. As part of the mysqlbackup invocation, specify the appropriate --user, --password, --port, and/or --socket options that are necessary to connect to the MySQL server. These connection options can be a part of [client] group in configuration files. mysqlbackup reads your default configuration files and then the my.cnf file specified on the command line. mysqlbackup reads only --user, --password, --port, and --socket options from the [client] group, and ignores any other options. If you do not provide a value for --password, the command prompts for one from the keyboard.