8.1.2 MySQL backup script (mysql_backup_script) asks for user password

[Mike_Gavrilov]

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.