SitePoint Sponsor

User Tag List

Results 1 to 9 of 9
  1. #1
    SitePoint Zealot
    Join Date
    Jan 2009
    Posts
    144
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Remote Access To MySQL on sharing host

    I am wondering if anybody knows it is possible to enable remote access to mysql on sharing host. Maybe with htaccess? Or any other way?

    Thank you

  2. #2
    Utopia, Inc. silver trophy
    ScallioXTX's Avatar
    Join Date
    Aug 2008
    Location
    The Netherlands
    Posts
    9,097
    Mentioned
    153 Post(s)
    Tagged
    2 Thread(s)
    The only way you can enable remote access to MySQL is through editing the MySQL server configuration (my.ini). Since shared hosts won't let you do this for obvious reasons you're out of luck.
    Why do you want to do this? Several programs you can use on the desktop (like SQLYog or HeidiSQL) can also connect to a remote MySQL through an SSH tunnel, which is pretty easy to set up. You'd need SSH access for that of course.
    Failing that, with SQLYog you can put a PHP script on the server and "connect" to that.
    If all else fails there is of course PhpMyAdmin, but I would use that as a last resort only.
    Rémon - Hosting Advisor

    SitePoint forums will switch to Discourse soon! Make sure you're ready for it!

    Minimal Bookmarks Tree
    My Google Chrome extension: browsing bookmarks made easy

  3. #3
    SitePoint Zealot
    Join Date
    Jan 2009
    Posts
    144
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The reason for that is because I don't have any database account in this hosting package. It is very cheap, and that is why it doesn't offer that. But I have another hosting provider where I have some databases left, but not any extra domains. I will later buy higher package and move everything to one provider, but not before I make some tests.

  4. #4
    Utopia, Inc. silver trophy
    ScallioXTX's Avatar
    Join Date
    Aug 2008
    Location
    The Netherlands
    Posts
    9,097
    Mentioned
    153 Post(s)
    Tagged
    2 Thread(s)
    So you want the host to connect to a MySQL database on your own PC or something?
    Rémon - Hosting Advisor

    SitePoint forums will switch to Discourse soon! Make sure you're ready for it!

    Minimal Bookmarks Tree
    My Google Chrome extension: browsing bookmarks made easy

  5. #5
    SitePoint Zealot
    Join Date
    Jan 2009
    Posts
    144
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No, to another website. I have two websites, each one on different host. One host has no databases and nother has many databases, but not any domain left.

  6. #6
    Utopia, Inc. silver trophy
    ScallioXTX's Avatar
    Join Date
    Aug 2008
    Location
    The Netherlands
    Posts
    9,097
    Mentioned
    153 Post(s)
    Tagged
    2 Thread(s)
    Have you tried connecting to the MySQL on the remote host? If that didn't work I'm afraid you're out of luck. You could try to write an API and use that instead of connecting to MySQL directly, but does seems a bit overkill to me.
    Have you contacted the host where you do have MySQL and ask if you could get an extra domain? They'd probably be willing to help you out.
    Rémon - Hosting Advisor

    SitePoint forums will switch to Discourse soon! Make sure you're ready for it!

    Minimal Bookmarks Tree
    My Google Chrome extension: browsing bookmarks made easy

  7. #7
    Twitter: @TimIgoe silver trophy TimIgoe's Avatar
    Join Date
    Feb 2005
    Location
    Blackpool, UK
    Posts
    1,058
    Mentioned
    27 Post(s)
    Tagged
    1 Thread(s)
    Its an option in the my.cnf / my.ini as has already been said - to either enable networking, or to bind to a certain IP address on the host. Most shared hosting providers SHOULD have this locked down (not internet accessible) so I'd guess you are probably out of luck there. Best solution is to upgrade your package so you can do what you need to without faffing. MySQL over the internet isn't the best for performance, especially if the servers are in different areas of the world (trust me... I've tried it, transatlantic, while migrating a website)

  8. #8
    SitePoint Wizard bronze trophy Immerse's Avatar
    Join Date
    Mar 2006
    Location
    Netherlands
    Posts
    1,661
    Mentioned
    7 Post(s)
    Tagged
    1 Thread(s)
    As an alternative, you might be able to use SimpleSQL on the the cheap server?

  9. #9
    SitePoint Wizard silver trophy ldcdc's Avatar
    Join Date
    May 2004
    Location
    Ploiesti
    Posts
    4,475
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am wondering if anybody knows it is possible to enable remote access to mysql on sharing host.
    This should be possible via your hosting control panel (some hosts will not offer it though). Other than that, your best bet is to contact your host and ask for assistance.. or plea for a bit of understanding.

    MySQL over the internet isn't the best for performance
    Quite true. Given that Google now takes website load speed into account, it may be yet another reason to consider getting proper hosting for the site, if getting traffic to it is important.
    HostPeek.com - budget hosts, compared
    CouponsNexus.com - web hosting coupons

    Ultra Cheap Hosts | Web Hosting Reviews Forums


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
  •