I'm desperate I have a MySql server (Xampp) running on the computer. Now I want to access the server from the laptop (e.g. Through a Winforms app). The laptop does not receive the ports either (test with "netstat -ano"). I've already tried a lot, but somehow it doesn't work.
Can someone roughly tell me what to do to make it work?
Thank you in advance!
PS: I don't know anything about MySQL at all. I don't want to use the server for a website but for Winforms.
Can you explain in more detail what you do where and how?
xamp installed on an extra computer?
mysql access from outside allowed?
does the ping go, port 3306?
what do you get for error messages?
If you then access the local phpmyadmin, which in turn accesses the local database… So release port 80 on the computer with xampp…
If you want to access the database directly, you have to enable port 3306 on the computer running MySQL…
Winforms doesn't tell me anything. A MySQL server listens to port TCP 3306. If netstat does not list this port, the MySQL server will not run. The XAMPP control panel should actually display this. If the MySQL server is running, access may be blocked by the Windows firewall. You then have to approve external access.
The database server must be bound to the IP of the network card (LAN)
The database server must allow connections from the laptop's IP / local network
The database user must have remote access rights *
The database must allow access via the network *
(*) Varies with different DBMSes, how MySQL handles this exactly reveals the documentation.
The client (laptop) must then of course also connect to the IP of the DB server.
