How to leave a mysql database online?

Asked

Viewed 1,390 times

-1

I have a database on my computer, but I need to share it with other people. I’m using the Mysql database, and I need to access this database off the network, on other devices. How to leave this database online and share it with other people ? I need to share the database, because other applications will access it. How to perform ?

mysql

1 answer

1

First you need to know if the "external IP" of the Windows Server network is fixed or not, being fixed just know the address, then the next steps are:

  1. Fix the "local IP" of your Windows Server (maybe this step is already done, I understand from your site, since IIS is already released)

  2. Release mysql port which should probably be the 3306 (standard) in the VirtualServer with the machine’s local IP, as described in external access with wamp (ignore the no-ip part if your IP is fixed)

    It is good to note that this example I followed in a basic equipment, being a complex network the best is to request the release of the door 3306 for the network administrator(s) (s)

  3. If your network is simple once released Virtualserver > Forward, then just try to access from another network, such as a 3g or 4g network by CMD the command:

    telnet x.x.x.x 3306

    Exchange the x.x.x.x by the external IP that is used on the Windows Server network.

  4. Extra: If your IP is not fixed and your network is simple/home so you can access IIS and mysql externally you will need to configure no-ip, as described in the link in "step 2" (above), then after releasing via no-ip just test the port in cmd (using a 3g or 4g network), a dummy example:

    telnet meusite.no-ip.biz 3306

  5. Extra: I don’t have many network details, the examples above are for a "simple network", in case the network is more complex recommend that asks the network administrator to release the port to you, he will know how to do this easily.

    So if this is the case, after the administrator confirms that you have released the port and you have a valid HOST (or fixed IP of this such network) just use one of these two (using a 3g or 4g network):

    If it’s just the IP:

    telnet x.x.x.x 3306

    If you have a "hostname configured":

    telnet meusite.com 3306

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.