mysql workbench连接数据库报错:Authentication plugin ‘caching_sha2_password‘ cannot be loaded

这是因为 : 8.0加密方式是（caching_sha2_password）有些 mysql workbench 客户端还不支持. 因此需要修改 mysql 用户密码的加密方式.
https://dev.mysql.com/doc/refman/8.0/en/caching-sha2-pluggable-authentication.html.
查看加密方式:

select user, host, plugin, authentication_string from user\G;

修改

  ALTER USER 'baidu'@'%' IDENTIFIED BY 'baidu123456' PASSWORD EXPIRE NEVER;   #修改加密规则 
 
  ALTER USER 'baidu'@'%' IDENTIFIED WITH mysql_native_password BY 'baidu123456';   #更新一下用户的密码 

更新

FLUSH PRIVILEGES;