MYSQL DB and Internet

[Kingmen30264]

I was wondering how I could get certain programs, or access to my DB from anywhere. From time to time I am gone for awhile, sitting around not doing anything and would like to load up EQ_ITEMS and edit the items in my DB, or one of Georges Tools and edit something in my DB while I wait.

I tried a few options already, but it doesn't seem to be working. Here is what I have tried thus far:

1. Enabled the port to my DB
2. Changed the db.ini file(s) to match the hosting my server (I have a dynamic IP)

Noting has worked so far. Now when I try to log on using the information to my server, it will sit there and try to connect to it, but it can't. If I change it to something else (using the same guideline something.something.ext) then it will instantly time out. So I KNOW it is seeing my DB, but how do I allow connection to it?



Any and all help with this is greatly appreciated.

Thanks,
Kingmen

(P.S. I know that opening my DB can cause vulnerabilities, I am not concerned on that point, but merely the one that I posted above.)

[trevius]

As long as you have port 3306 opened in your router/firewall, the only other thing you should need to do is to create a MySQL user that can access your DB from any host. By default, most usernames are set to only allow access from the local host, unless you specify otherwise.

Also, on windows installs of MySQL, during the setup there is an option checkbox that you need to set to allow remote connections to the DB.

Once you have all of that stuff set, it should work.

[pfyon]

You should also check mysql config file (my.cnf) and change bind-interface to the local IP of the server (by default it's 127.0.0.1, or localhost, I believe). This is the IP it will listen on for connections.

edit: I now realize that's probably what that windows checkbox that trevius mentioned does