Closed Thread
Results 1 to 8 of 8

Thread: can I access mysql remotely?

  1. #1
    lhorace is offline x10Hosting Member lhorace is an unknown quantity at this point
    Join Date
    Apr 2008
    Posts
    14

    can I access mysql remotely?

    I notice remote access in Cpanel where you can define what host can connect to MySQL. I have a VPS account and I would like to remotely access my database, is that possible? I haven't found a reliable thread to elaborate this question in detail =] Thanks

  2. #2
    Anna's Avatar
    Anna is offline I am just me Anna is a name known to allAnna is a name known to all
    Join Date
    Aug 2007
    Location
    Sweden
    Posts
    6,569

    Re: can I access mysql remotely?

    On a VPS, yes.

    All you'd have to do is make sure the firewall accepts incoming connections on the mysql port. And add the IP you will be connecting from in the remote hosts table in cPanel.

    Ps. thread moved to VPS talk as this does not concern our free shared hosting.
    Do you have trouble reaching your site?
    Check here first: News and Announcements


    Don't forget that x10hosting has an irc server as well. Come and join the fun
    server: irc.x10hosting.com, main channel: #x10hosting
    There's a lot helpful users there if need help building your site

  3. #3
    lhorace is offline x10Hosting Member lhorace is an unknown quantity at this point
    Join Date
    Apr 2008
    Posts
    14

    Re: can I access mysql remotely?

    I wanted to access my x10hosting free website database remotely, not access my MySQL server on my VPS remotely =]

    From my VPS, I wanted to access my website database on starka, to get some queries? :\ if it's all possible?

    ---------- Post added at 02:03 PM ---------- Previous post was at 01:22 PM ----------

    I guess my answer was answered

  4. #4
    Livewire's Avatar
    Livewire is offline Abuse Compliance Officer Livewire is a glorious beacon of lightLivewire is a glorious beacon of light
    Join Date
    Jun 2005
    Location
    Behind a keyboard.
    Posts
    8,998

    Re: can I access mysql remotely?

    There's an addon you explained which changes things a bit; you can't access starkas mysql remotely, but your vps is a different issue. If you want to access the VPS's data remotely you can. The free servers block the mysql port by default in the firewall though, so even if you allow it in cpanel on the free account it won't actually make it to the server


    TOS breakers will be suspended regardless of race, creed, national origin, hair color, or favorite food. Thanks for your understanding!

  5. #5
    lhorace is offline x10Hosting Member lhorace is an unknown quantity at this point
    Join Date
    Apr 2008
    Posts
    14

    Re: can I access mysql remotely?

    That's unfortunate, I'm going to have to find another solution. Thanks allot =]

  6. #6
    Livewire's Avatar
    Livewire is offline Abuse Compliance Officer Livewire is a glorious beacon of lightLivewire is a glorious beacon of light
    Join Date
    Jun 2005
    Location
    Behind a keyboard.
    Posts
    8,998

    Re: can I access mysql remotely?

    Random question/idea.

    Can you move the free hosting databases to the VPS, and have the free hosting account contact the VPS MySQL remotely instead of the other way around?


    Assuming that'd work, then the VPS would have -direct- access to what's on the free hosting account. From what I understand as well, remote mysql is blocked on free but only on inbound - an outgoing connection to the VPS shouldn't get blocked, if I read it right.


    It's an idea but I would HIGHLY recommend backing up the databases first, just in case it epic-fails. It's an idea to think about though


    TOS breakers will be suspended regardless of race, creed, national origin, hair color, or favorite food. Thanks for your understanding!

  7. #7
    lhorace is offline x10Hosting Member lhorace is an unknown quantity at this point
    Join Date
    Apr 2008
    Posts
    14

    Re: can I access mysql remotely?

    Yeah, one of my Admins came up with that idea already but we're still deliberating on SQL Server software atm... Thanks for the suggestion ;)

    ---------- Post added 02-01-2011 at 02:24 AM ---------- Previous post was 01-31-2011 at 04:18 PM ----------

    This forum can be closed

  8. #8
    Livewire's Avatar
    Livewire is offline Abuse Compliance Officer Livewire is a glorious beacon of lightLivewire is a glorious beacon of light
    Join Date
    Jun 2005
    Location
    Behind a keyboard.
    Posts
    8,998

    Re: can I access mysql remotely?

    Can't close the entire forum but I can close the thread

    Closing at customer request.


    TOS breakers will be suspended regardless of race, creed, national origin, hair color, or favorite food. Thanks for your understanding!

Closed Thread

Similar Threads

  1. Cannot access Mysql remotely
    By flavioa.mello11 in forum Free Hosting
    Replies: 3
    Last Post: 11-07-2010, 07:28 PM
  2. Cant Connect Remotely to MySQL
    By shade-jj82 in forum Free Hosting
    Replies: 1
    Last Post: 07-11-2010, 11:43 PM
  3. access mysql database remotely possibilities for free user.
    By siekkwangcin in forum Free Hosting
    Replies: 2
    Last Post: 04-07-2010, 11:31 PM
  4. Unable to remotely connect to MySQL?
    By LyteNight in forum Free Hosting
    Replies: 3
    Last Post: 03-16-2010, 05:12 PM
  5. Access mySQL remotely?
    By ionutz in forum Free Hosting
    Replies: 3
    Last Post: 02-07-2008, 01:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers