Member Avatar for Dartz654

So, I need to let a Visual Basic application connect to my XAMPP MySQL server. I set up the .Net/SQL Connectors, XAMPP, and all that other good stuff. When I try to connect to the server using 192.168.1.2 (my static IP) it will work. When I try to connect to it using 69.231.119.20 (Which is what I believe I need to do, so I can distribute the program...) it says the server is unavailable. So, I'm assuming I have to portforward something? I portforwarded 80 so you can see the webpages at http://69.231.119.20, but do I have to portforward something else to allow remote mysql connections? Also, i tried adding the bind thing to the my.ini file, that didn't work.

  • 2 Contributors
  • 2 Replies
  • 283 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by Dartz654
Member Avatar for pritaeas

MySql default port is 3306, so forward that too (unless you changed it in the setup).

Member Avatar for Dartz654

Worked, thanks :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.