大网数据广告活动
服务器运维问答

Mysql connection not working with Windows Firewall on

· 52CE 我爱测

Using Windows 7 Pro, Mysql server 5.7 installed on local pc. It was working till the pc moved to another private network. When I open Mysql Workbench and click the only connection I have, it doesn't ask for any password, when it …

问题原文

原帖链接 · tec · CC BY-SA 3.0

Using Windows 7 Pro, Mysql server 5.7 installed on local pc.

It was working till the pc moved to another private network. When I open Mysql Workbench and click the only connection I have, it doesn't ask for any password, when it should, it did before. When I disable Windows Firewall all its fine, I tried to add Indbound and Outbound exeptions to 3306 port TCP, in Private and Domain mode to the Windows Firewall, but when I close the windows the rules disappear, the name is codified, and other rules just doesn't add.

mysqld.exe is the only service of mysqlserver present in inbound and outbound rules.

Edit:

Modifying the connection in the workbench from 'localhost' to 'serverIP' (wich is the same host) works. But doesn't work for other programs which need connection too. Any suggestion?

已采纳解答

原帖链接 · tec · CC BY-SA 3.0

Solved, it was another firewall that was giving issues with Windows services and other stuff. I had to add rules in Control Panel/Windows Firewall/Advanced settings/Inbound rules and add new rule for connections over port 3306

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2017-01-03)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 3.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。