【报错】局域网连接MySQL 报错 was not registered for synchronization because synchronization is not active

约定不等于承诺〃 2024-04-18 19:41 115阅读 0赞

`昨天把一个SpringBoot的Demo部署在虚拟机上的时候，访问电脑的MySQL的时候反应连不上`

###### 1 、配置文件的url没改，连的本地的直接写的是127.0.0.1，虚拟机根本没装所以连不上 ######

改成局域网的192.168.1.59，还是连不上报错 was not registered for synchronization because synchronization is not active

`was not registered for synchronization because synchronization is not active`

###### 2、综合一下解决方法 ######

*  1、MySQL 的 mysql库中找到 user表 ，反正是本地的，我就全部改成`%`![在这里插入图片描述][20190911101741153.png]
 *  2、刷新MySQL配置  
    执行一下 `flush privileges;`
 *  3、关一下本地的防火墙`或者开放3306端口号也行`
    
     *  3.1 进入控制面板
     *  ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70]  
        3.2进入防火墙找到高及设置

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 1]  
3.3 右击新增入站规则

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 2]  
3.4选择端口 下一步  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 3]  
3.5选择TCP 特定本地端口 MySQL端口号默认3306  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 4]  
3.6允许连接下一步  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 5]

3.7 . 全选下一步  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 6]

3.8 取名称 完成![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 7]

[20190911101741153.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/535697bc63a24a2582323b0c2dd20d48.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/a0d7ee69ff4f41b797426d3e8faeb9c9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/a65eaa56f8b84cc0a9cce0b33edbe20b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/8541333d258842a184234a8b056f6089.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/6a95e08aabfa43cca82912fd28c9f84d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 4]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/13ca287b9b7a437ba93da506bce983c9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 5]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/f405a81d73d743448a36821d48daadd8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 6]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/72eef7c2857740649c576aa691ac07fb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4NjI2NTk1_size_16_color_FFFFFF_t_70 7]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/a5f86d093a11416bbf8b178d574a4ca0.png