In my multiserver setup, the db backup also doesn't work. The webserver is on a different server than the db server. I have updated my mysql_clientdb.conf file accordingly:
$clientdb_host = 'db1.domain.tld';
$clientdb_user = 'root';
$clientdb_password = 'rootpassword for mysql on db1';
Mysqldump and sudo is installed on both servers.
However, if I do:
mysqldump -h db1.domain.tld -u root -p c1testdb1 > c1testdb.dump
Access denied for user 'root'@'web1.domai.tld' (using password: YES) when trying to connect
Does that indicate the problem?