skip to Main Content

My WAMP server, Apache is online, everything is working. My ports 80 and 3306 are open, I can access my server from outside. I can also access PhpMyAdmin from "http://MyIPAddress/PhpMyAdmin". however, I can’t find a way to access my database outside.

For the host parameters I tried:

MyPublicIP:3306 (Error: Too long to respond / It works with localhost)
I can make php requests with host 127.0.0.1:3306, it works even online in Php Page, but I can’t connect directly my DB online…

I need to connect my database to an application on a remote computer. Except with a VPN, I didn’t find any solutions and I searched in all WAMP parameters to put MySQL online.

2

Answers


  1. Given that your server already opens block 3306,

    You need to enable remote access for the user (from localhost to "any") accessing the database.

    enter image description here

    Login or Signup to reply.
  2. First check if your MySQL is bind to localhost or any host (0.0.0.0 or *)

    If its already bind to any host, the next would be to see if your firewall/router is allowing the port, you might need to do a port forwarding on your router.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search