Hello,
We newly build the 3 node innodb cluster. we have configured the backup tool (Micro Focus - Data protector).
Mysql EE 8.0.31 with RHEL OS.
If we take the backup from root user, getting below error.
230105 12:34:04 MAIN ERROR: Cannot establish connection for user 'root'
to mysql server at eiacdb1prd:3306. Connection open fails with error
"Access denied for user 'root'@'eiacdb1prd' (using password: YES)"
230105 12:34:04 MAIN ERROR: Connection initialization error.
And I created separate user for backup and granted the needed privilege, if we use backupadmin user, getting below error,
[Critical] From: INET@eiacdb1prd "" Time: 1/5/2023 12:38:12 PM
[70:2] User "backupadmin" non-existent on this host => aborting
[Normal] From:
BSM@xxxxxx.yy.zzz.ae "MySQL-EIAC-TEst" Time: 1/5/2023 12:38:47 PM
OB2BAR application on "eiacdb1prd" disconnected.
[Critical] From:
BSM@xxxxxx.yy.zzz.ae "MySQL-EIAC-TEst" Time: 1/5/2023 12:38:47 PM
None of the Disk Agents completed successfully.
Session has failed.