如何从外部IP连接XAMPP MySQL并实现服务器公网可访问？

Got it, let's figure out how to get your XAMPP server accessible from anywhere on mobile data—since you already have it working on the local network, you're halfway there! Here are the most practical methods to make it globally reachable:

This is the standard way to expose your local server to the public internet, and it requires configuring your office router:

• First, find your XAMPP server's local IP address. On Windows, open Command Prompt and run ipconfig—look for the IPv4 address under your active network adapter (like 192.168.1.105). On Linux/macOS, use ip addr or ifconfig instead.
• Next, log into your router's admin panel. Type your router's gateway address (usually 192.168.1.1 or 192.168.0.1) into your browser, then enter the admin username and password (you'll find these printed on the router itself if you haven't changed them).
• Look for a section called Port Forwarding or Virtual Server (the name varies by router brand).
• Create a new forwarding rule:
  • External Port: Pick a port to expose publicly—use 80 for HTTP or 443 for HTTPS if your ISP allows it. If those are blocked, use a custom port like 8080.
  • Internal Port: Match the port your XAMPP service uses—Apache defaults to 80, MySQL to 3306 (though I strongly recommend not exposing MySQL directly to the internet).
  • Internal IP: Paste the local IP of your XAMPP server you found earlier.
  • Protocol: Select TCP (or TCP/UDP if you need it, but TCP is enough for web traffic).
• Save the rule and restart your router to apply changes.
• Test it out: On your mobile data, visit your public IP plus the port (e.g., 123.45.67.89:8080). To find your public IP, just search "what's my public IP" in a browser on the server.

Most office/home ISPs assign dynamic public IPs that change over time. DDNS fixes this by linking a fixed domain name to your changing IP:

• Sign up for a DDNS service (many routers come with free built-in options, or you can use services like No-IP).
• Go back to your router's admin panel, find the DDNS settings, and enter your service credentials. This will bind your current public IP to a custom domain (like my-office-server.ddns.net).
• Make sure you've already set up port forwarding as above.
• Now you can use this DDNS domain instead of your public IP to access the server—even if your IP changes, the domain will automatically update to point to the new one.

If router config feels too technical, or your ISP blocks common ports like 80/443, reverse proxy services are a great alternative:

• Tools like Ngrok or Cloudflare Tunnel create a public URL that forwards traffic directly to your local XAMPP server.
• For example, with Ngrok:
  • Download the Ngrok client to your XAMPP server.
  • Open Command Prompt/Terminal, navigate to the Ngrok folder, and run ngrok http 80 (replace 80 with your Apache port if you changed it).
  • Ngrok will spit out a public URL (like https://xyz789.ngrok.io)—use that on your mobile data to access your server instantly.
• Note: Free Ngrok plans give random URLs that change every time you restart the tool. Cloudflare Tunnel is free and lets you use a fixed custom domain, though setup takes a bit more time.

• Never expose MySQL ports directly to the internet: If you need remote database access, use an SSH tunnel or VPN instead—it's way safer.
• Update your firewall: Make sure your server's firewall (Windows Defender Firewall, UFW on Linux) allows incoming traffic on the ports you're using (80, 8080, etc.).
• Use HTTPS: For public access, set up an SSL certificate (XAMPP works with Let's Encrypt) to encrypt traffic and avoid browser warnings.
• Restrict access (optional): If you only want specific people to reach the server, add IP whitelists in your router's port forwarding settings or edit Apache's httpd.conf to block unwanted IPs.

内容的提问来源于stack exchange，提问作者Ankit Singh