First to the steps above if you haven't done them yet.
This is only one method to set this up, but I think it should work for most people. Lets go through it step by step.
Your database uses the port 3306 to „speak“ with other applications. You need to add an exception to your firewall so other computer in your home network are allowed to use this port. Go to Control panel -> Windows Firewall -> Advanced Settings -> Incoming Rules. Next click on „New Rule“ on the right. Port -> TCP and 3306 -> Allow -> Domain and Private/Home -> MySQL. You can do the same procedure under Outgoing Rules later if you're having issues.
Now you need to reach your computer from outside. But everytime your router connects to the internet he gets another random IP. So you will instead use a „name“ for your computer and let him update the IP behind the name as soon as he gets a new one.
Go to
[Only registered and activated users can see links. Click Here To Register...] and sign up for a free account. Write down the data as you will need it later. The hostname „xxx.ddns.net“ ist he „name“ for your computer. You’ll need to confirm your email address by clicking on a link in the email you get after registration. Now download the application
[Only registered and activated users can see links. Click Here To Register...]. Install it and sign in. Once you logged in go to Edit Hosts -> select your name -> click OK. Now you can also setup the autostart oft he tool. Go to File -> Preferences -> Startup -> hit the second box. Under network adapter make sure no „VMware …“ is selected. There has to be the „Windows default“ or your primary internet connection. Now you can close it, it will stay open in the taskbar.
Now comes the tricky part. Until now you can only reach your router with the address, not your PC. You need to configure your router to pass all incoming network trafic on port 3306 to your PC in order to reach him the from internet. This is called „Port Forwarding“. And it’s different for every router!!! So there is no way I can offer you a special guide on how to setup your router, sry :( You have to try it yourself or search on google how to set it up… But here are the basic steps if you can’t find a guide:
You’ll need the local IP of your router. It is the IPv4-standardgateway you wrote down earlier. Enter it into your browser and hit enter. Most likely you will be prompted for a user + password. Either you wrote it down once you set up your router, it is written on the back of your router or there is still a default combo (google for the default credentials of your specific router). Once you logged in you may have to browse through every menu and looking for something like „Port Forwarding“, "Sharing" or „Rules“. Add a new rule pointing to your static IP (IPv4-address from earlier). The port is 3306 (local and remote if asked) and the protocol is TCP. Save it and pray to god it works :D