Alright, so I have been using XAMPP for some very basic personal hosting for a long time, everything works perfectly. However, what I would like to do is be able to access my database from a remote computer (not locally). I have MySQL Workbench on my laptop and I'll be going away for a couple of weeks on a business trip. I would like to be able to connect to my database remotely. I have already have set up a static host name and port 3306 is already being forwarded to the main computer in the office.
Here is my approach of how I think it should work.
Server: http://www.hostname.com:3306
User: root
Password: password
When I try to connect to this using MySQL WorkBench, I get an error:
FAILED to connect to MySQL at http://www.hostname.com with user root. Host is not allowed to connect to this MySQL Server.
Is there a security feature in XAMPP that doensn't allow inbound connections or something? Or is it something I'm missing completely to my approach.
I need help!