Results 1 to 2 of 2
  1. #1
    Registered User matt001's Avatar
    Join Date
    Sep 2003
    Location
    Brisbane, QLD
    Posts
    741
    cPanel Remote MySQL Solution Needed
    Hi Guys,

    We have an MS Access database that connects to a remote MySQL Database on a cPanel VPS. We are getting the access database moved over to PHP / Web-based in the next 6months.

    Connecting remotely to the database works perfectly if you have a Static IP Address or a dynamic IP address and use a dyndns hostname.

    We have hit abit of a snag we are wanting our sales rep to start using the access database on his laptop that connects to the database remotely while he is on the road. But the Telstra 4g Hotspots / Dongles don't give out public ip addresses. We can't use a dyndns hostname.

    I really don't want to put the % sign in to open up the MySQL remotely to everyone in the world. What do people do in this situation.

    Matthew
    Matthew - A+ Certified PC Technician
    Contact: matthew01@gmail.com

  2. #2
    Registered User brianoz's Avatar
    Join Date
    Nov 2004
    Location
    Melbourne
    Posts
    931
    There are two techniques for this that you could use. A dyndns solution is probably the simplest, though it could take a few minutes to kick in (perhaps that's why you say you can't use it). You'd run a small client on the laptop to confirm the IP.

    However, a faster solution might be to use port knocking. With port knocking, you connect to a fixed port (known in advance) or two in a specific order, and that "unlocks" the MySQL port for you to connect to. For instance, you might connect to port 3613, then 2476, then 45130, then that would open the mysql port. This can be scripted up pretty easily and would only take a few seconds to run. CSF supports port knocking, you'd need to talk to your host to get it implemented.

Similar Threads

  1. Remote Gaming MySQL?
    By CRAZYxMUNK3Y in forum Web Hosting Australia
    Replies: 5
    Last Post: 18-02-2012, 10:40 PM
  2. ZEBRA SALE - 60% OFF / 3 and 6 Months FREE / FREE UPGRADES!!
    By ENXASH in forum Australian Shared Web Hosting Offers
    Replies: 16
    Last Post: 18-04-2009, 09:52 AM
  3. [UK] Cpanel hosting plans from 19.99 / year
    By James-A in forum International Offers (LINK)
    Replies: 0
    Last Post: 15-11-2008, 05:51 AM
  4. ODBC Filmaker 9 remote accessible MySQL hosting needed
    By Fungyo in forum Australian Shared Web Hosting Requests
    Replies: 5
    Last Post: 15-08-2007, 10:18 PM
  5. Sydney cPanel Hosting - $6
    By CoffeeCoder in forum Australian Shared Web Hosting Offers
    Replies: 0
    Last Post: 29-08-2006, 04:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •