I'm preparing to migrate a large number of cPanel accounts running database-driven sites (lots of WordPress for example) from old servers running MySQL 5.7 to new servers running MySQL 8.0.36
However, the new servers are showing a ton of this constantly in the logs:
[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'
And also occasionally this:
[Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
So my concerns are:
1. Is there specific documentation on how to correctly fix this and switch from mysql_native_password to caching_sha2_password ?
2. If I were to switch to caching_sha2_password on the new MySQL 8 servers before migrating all of the user accounts from the old MySQL 5.7 servers, will that "break" the sites / databases that I transfer to the new servers?
Migrating my whole operation to new boxes is anxiety-inducing enough even without this issue, so some clarity / clarification on this would be extremely helpful.
I know that I can suppress the massive number of warnings being generated into the logs with methods like this - https://support.cpanel.net/hc/en-us/articles/16550190886935-MySQL-log-warning-mysql-native-password-is-deprecated-and-will-be-removed-in-a-future-release - but that's obviously not actually fixing anything.
Can someone please advise?
Please sign in to leave a comment.