远程连接docker创建的mysql容器失败,报错:Client does not support authentication protocol requested by server;consider upgrading MySQL client
方法:进入容器中的mysql数据库,执行命令
CREATE USER 'wkcto'@'%'IDENTIFIED WITH mysql_native_password BY '123456';
wkcto 为新建用户名
GRANT ALL PRIVILEGES ON *.* TO 'wkcto'@'%';
然后将链接名改为 wkcto即可