I use MySQL version 8.0.34 on a Debian server. With the latest update I get the message that mysql_native_password is deprecated and I should rather use caching_sha2_password instead. With my own users this is no problem, here I can simply change the authentication plugin.
ALTER USER user IDENTIFIED WITH caching_sha2_password BY 'password';
But what about the integrated users mysql.sys, mysql.session and debian-sys-maint? I did not create these, they are not intended for a user login and I accordingly do not have a password for them. How can I change to caching_sha2_password here?
ALTER USER user IDENTIFIED WITH caching_sha2_password;
Omitting the password in the SQL statement only results in errors.