Error Code: [19:1109] Backup goes into pending state with MySQL error

Article ID: MSQL0003 A backup operation for MySQL goes into pending state with error Error Code: [19:1109]

Symptom

A backup operation for MySQL databases goes into pending state with the following error in the MySqlBackup.log file on the client computer where the MySQL Agent is installed. The log file is located in software_installation_path\Log Files.

GetMySqlInfoExt::ConnectToDB() - Cannot connect.GetConnection failed()

You can also see the following error in the error log on the MySQL server:

The plugin '*2304CA907AD20C629F898FCE11C167F21663318A' used to authenticate user 'MySQL.Backup'@'%' is not loaded.

Cause

A wrong value is set for MySQL plug-in on the MySQL server.

Resolution

To set the correct value for MySQL plug-in, from the MySQL server, run the following command:

update mysql.user set plugin=<plugin_value> where user=<username>

For example:

update mysql.user set plugin='mysql_native_password' where user='user1'