解决mysql 权限问题

远程连接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即可

上一篇:Consider defining a bean of type 'com.*.*.mapper.*.*Mapper' in your configuration.


下一篇:C++ error C4996: 'strcpy': This function or variable may be unsafe. Consider using strcpy_