Switch to caching_sha2_password safely?

Metro2

• February 09, 2024 15:26
• Edited

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?

• 

  cPRex Jurassic Moderator

  • February 09, 2024 19:43

  Hey there!  The answer at this time is "ignore it for now" since cPanel doesn't have full support for the new version just yet, as that article you posted mentions.  I'm sure we'll have a large announcement when this is supported.

  0

Please sign in to leave a comment.