- 安装参考链接:https://blog.csdn.net/u014069688/article/details/100532774?utm_source=app&app_version=5.3.0&code=app_1562916241&uLinkId=usr1mkqgl919blen
- docker中安装mysql 参考链接:https://blog.csdn.net/qq_22211217/article/details/80414227?spm=1001.2101.3001.6650.4&utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-4.pc_relevant_default&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7ECTRLIST%7ERate-4.pc_relevant_default&utm_relevant_index=9
- 在容器中连接成功后设置mysql远程连接的权限
命令:use mysql;
命令:select host,user from user;
命令:ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
命令:flush privileges;
- 在navicat中连接mysql
虚拟机ip,宿主机端口,mysql用户名,mysql密码输入即可成功连接mysql