Search code examples
c#mysqlwinformsxampp

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

I have wrote a simple program which uses MySQL db server of XAMPP. Program works fine when I connect to 'localhost':

enter image description here

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

enter image description here

it gives below error:

enter image description here

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

enter image description here

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

Solution

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

    enter image description here

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

    enter image description here

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