选择配置管理
![在这里插入图片描述](https://img-blog.csdnimg.cn/20200219093556803.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3MzgzODY2,size_16,color_FFFFFF,t_70)
![在这里插入图片描述](https://img-blog.csdnimg.cn/20200219093704918.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3MzgzODY2,size_16,color_FFFFFF,t_70)
![在这里插入图片描述](https://img-blog.csdnimg.cn/20200219093837160.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3MzgzODY2,size_16,color_FFFFFF,t_70)
这样3306 就对外释放了
二.使用SQLyog连接时出现 plugin ‘caching_sha2_password’ cannot be loaded此错误解决:
ALTER USER ‘root’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
ERROR 1045 (28000): Access denied for user ‘test’@‘x.x.x.x’ (using password: NO)
A: 原因是没有给登录用户名设置远程主机登录的权限。还有种可能是你需要重设下密码…可能是授权操作引起这种后遗症…
![在这里插入图片描述](https://img-blog.csdnimg.cn/2020021912405855.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L20wXzM3MzgzODY2,size_16,color_FFFFFF,t_70)