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; -- 刷新权限
然后就可以重新连接了