MySQL innoDB table backup fails when MySQL user password contains $ character.
Symptoms:
1) Backup fails with the following error.
- Failed to backup 'InnoDB' table ' ' for database ' '.
2) NetVault trace logs will include following mysql error.
mysqldump utility failed: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
Change the mysql user password so that it does not include the "$" character, modify MySQL APM configuration, then create a new job.
1. login.
# mysql -u root -p
Enter Password:
2. Change password.
mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
3. Configure the MySQL APM with the new password.
4. Create a new job in NetVault's Backup Window.
