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

Article ID: 54213

Article Type: Troubleshooting

Last Modified:

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

Symptoms

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.

Causes

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= where user=

For example:

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

1 Commvault Way, Tinton Falls, NJ 07724 Sitemap | Legal Notices | Trademarks | Privacy Policy
Copyright © 2022 Commvault | All Rights Reserved.