mysql8.0 的密码问题Unable to load authentication plugin 'caching_sha2_password'
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