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 viamysql_backup_script from the articlehttps://www.veritas.com/support/en_US/article.100041374 asks for password interactivelywhile "nbmysql -o backup" works fine Diagnosis It looks likemysql_backup_script ignores.mylogin.cnf and keep asking for the password but it's because of incorrect hardcoded connection string. It connectsto 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.1.1KViews0likes0Comments