''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

Products

• CA API Gateway

Issue/Introduction

We are seeing the following errors generated in our mysqld.log generated every minute:

[Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

Executing the following mysql query shows that there are no users defined which are even using the sha256 plugin:

select host, user, plugin from mysql.user;

Environment

CA API Gateway

Cause

The error in question can be generated when a mysql user which is not defined within the mysql.user table tries to connect over to mysql.  

We were able to determine that there was a monitoring script in place which was trying to connect over with a mysql user account that was not defined within the mysql user table.

Resolution

We disabled the monitoring script and the errors in question subsided.