Skip to main content

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

Aaron Gros
  • Updated

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

Related articles