How to connect C# Winform Project to the XAMPP MySQL server in LAN?-CodePudding

The

But when I try connect a MySQL db from another computer (in my LAN):

it gives below error:

But I can connect to that 'phpmyadmin' from browser:

(or Can it be that the computers which I'm testing are domain members ?)

CodePudding user response：

Please check your Firewall on the remote machine. It might block the mysql connection and has an exception rule for HTTP Ports, thats why phpMyAdmin is reachable.

CodePudding user response：

Actually the problem was, MySQL server settings has set to work only for local connections (by default):

So, then I uncommented the second line and chanded to:

And it worked. '127.0.0.1' means localhost and '0.0.0.0' means any host