MySQL log warning - ''mysql_native_password' is deprecated and will be removed in a future release

Symptoms

The MySQL log file is quickly filling with the following warning message.

2023-08-04T23:19:27.023454Z 20 [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'

Description

The mysql_native_password authentication plugin was deprecated in MySQL 8.0 in favor of the caching_sha2_password plugin, which cPanel doesn't yet support. The warning messages are designed to let system administrators know of the change. 

Workaround

Setting the log verbosity to 1 will prevent the warning messages from being logged.

1. Access the server's command line as the 'root' user via SSH or "Terminal" in WHM.
2. Open /etc/my.cnf in your preferred text editor.
3. Locate the log-error-verbosity entry.
   Please note that if the log-error-verbosity entry doesn't exist, it should be added as a new line under the log-error entry.
4. Set the value of the log-error-verbosity to 1.

   log-error-verbosity=1

5. Save the changes and exit the text editor.
6. Restart the mysqld service.

   /usr/local/cpanel/scripts/restartsrv_mysql

Additional resources

10.4 Changes in MySQL 8.0: caching_sha2_password as the Preferred Authentication Plugin

5.1.8 Server System Variables: log_error_verbosity