Re: MySQL 8.0.35 and mysql_native_password

[Mike Frank]

The hash used for mysql_native_password is SHA1 based. Its usage is deprecated. SHA-1 has been compromised for over 7 years (2017) and is not longer recommended.

For mysql user/passwords the newer caching_sha2 replaces mysql_native_password. So FYI your above statement is in reverse.

You should set
[mysqld]
default_authentication_plugin=caching_sha2_password

https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
To migrate a user to caching_sha2 - simply alter the user and reset the password.

See
https://dev.mysql.com/blog-archive/a-tale-of-two-password-authentication-plugins/

Note: we also support other external authentication methods (LDAP, AD, Kerberos, ...) as well as multi-factor authentication.