MYSQL8: Client Connection Caching-sha2-password Issue

Original: Mysql8: Client Connection Caching-sha2-password problem

When installing MYSQL8, if you choose Password encryption, and then use a client connection such as Navicate, will prompt the client connection caching-sha2-password , is because the client does not support this plug-in, can be modified by the following ways:

     #修改加密规则      ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;     #更新密码（mysql_native_password模式）        ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '{NewPassword}';

MYSQL8: Client Connection Caching-sha2-password Issue