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
Given that your server already opens block 3306,
You need to enable remote access for the user (from localhost to "any") accessing the database.
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.