8.1.2 MySQL backup script (mysql_backup_script) asks for user password
Symptoms
1) Backup initiated from the GUI stays in Running state
2) Backup initiated via mysql_backup_script from the article https://www.veritas.com/support/en_US/article.100041374 asks for password interactively while "nbmysql -o backup" works fine
Diagnosis
It looks like mysql_backup_script ignores .mylogin.cnf and keep asking for the password but it's because of incorrect hardcoded connection string. It connects to 127.0.0.1 instead of localhost and
'nbuuser'@'localhost'
and
'nbuuser'@'127.0.0.1'
are treated defferently.
Solution
It's just a workaround. When you create .mylogin.cnf via mysql_config_editor use:
mysql_config_editor set --host=127.0.0.1 --user=<user> --password
and when you create a user for nbu use:
CREATE USER 'nbuuser'@'127.0.0.1' IDENTIFIED BY 'password';
after that backup works.
P.S. Check the password before use it. MySQL still can't use passwords start with "#", "%" and so on.
Updated 6 years ago
Version 2.0