PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Saturday, July 2, 2022

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

 July 02, 2022     c#, mysql, winforms, xampp     No comments   

Issue

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



Answered By - Gamer In The Game
Answer Checked By - David Marino (PHPFixing Volunteer)
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © 2025 PHPFixing