mysql 远程用户连接问题-mysql版本8.0

mysql版本8.0

-- 创建 用户、密码

CREATE USER 'test1'@'%' IDENTIFIED BY '123456';

-- 授权用户所有权限

GRANT ALL PRIVILEGES ON *.* TO 'test1'@'%';

FLUSH PRIVILEGES; -- 刷新权限

然后连接报错：

Client does not support authentication protocol requested by server;consider upgrading MySQL client

ALTER USER 'test1'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

FLUSH PRIVILEGES; -- 刷新权限

然后就可以重新连接了