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

Products

• CA API Gateway

Issue/Introduction

 mysql log file is getting bigger in size and containing lots of warnings. These warnings are constantly increasing and appearing up in the mysql logs. Below is the warning that keeps ballooning the mysqld.log file.

2023-11-23T21:22:13.094959Z 913679 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead

Environment

CA API Gateway 10.1, 11.x

Cause

Mysql warning filling the log file every second with 

2023-11-23T21:22:13.094959Z 913679 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead

Resolution

1. Need to make a change on mysql server (if a cluster , in both nodes) to stop writing the [MY-013360]  warning message 

login mysql, run statement,

mysql> set global log_error_suppression_list='MY-013360';

 

2. modify my.cnf on both nodes as per the KB below

   MySQL log overfilled with WARNING "sha256_password'

 

3. backup the mysqld.log to another server, and you can empty it by running command :

cat /dev/null > /var/log/mysqld.log

Notes :
- the above steps fix the issue immediately without restart gateway or mysql.(there is no downtime). 
- on step 1 we update the variable log_error_suppression_list on the mysql server directly
-  the step2 we modify my.cnf to make the change permanently. 
(ie. the change on step 1 only for current running mysql process, the change will disappear after restart the mysql, so we need step 2 to keep the change)