Unable to load authentication plugin 'caching_sha2_password'

MySQL在8.0后验证方式由mysql_native_password变为caching_sha2_password

解决办法

mysql> alter user root@localhost identified with mysql_native_password by 'thenewpasswd';
Query OK, 0 rows affected (0.03 sec)

References:

https://blog.csdn.net/zeal4rea/article/details/80542658