How did I switch MySQL to `caching_sha2_password` instead of `mysql_native_password`?

MySQL
, ,
2

Step 1

How do I list all MySQL users with their authentication methods?

Step 2

I ran it for every MySQL user with mysql_native_password:

ALTER USER '<user>'@'<host>' IDENTIFIED WITH caching_sha2_password BY '<password>';

Step 2.1.

How did I fix «ERROR 1819 (HY000): Your password does not satisfy the current policy requirements» MySQL error for the debian-sys-maint user in Ubuntu 22?