Remote DB access hostname vs. IP

Discussion in 'Linux VPS/Dedicated - General' started by marcm, May 21, 2008.

  1. marcm

    marcm Member

    Hi everyone, I have a simple question for you. I use SQLyog for all of my remote database work. I love it. I notice that when I connect to my databases hosted on my VPS, I have to use the IP to connect. On my older shared hosting account I could use my domain to connect instead. As in http://www.mydomain.com

    I'm sure this can be achieved with my VPS, but I'm not sure how. Any ideas?

    Thanks,
    Marc
     
  2. khiltd

    khiltd New Member

    In what way does it fail?
     
  3. marcm

    marcm Member

    Error 2005,
    Unknown MySQL server host - (11004)

    Hmm ok. It doesn't like the http:// - even though I swear I used that on my win2k box :p
    so just using the domain works - mydomain.com etc. as well as the IP
     
  4. khiltd

    khiltd New Member

    Unless you managed to get mysql bound to port 80 it's unlikely that it ever worked over HTTP. Addresses and URLs are two very different things.
     
  5. marcm

    marcm Member

    Nope - I just checked my laptop - using SQLyog 5 - I'm still accessing my database on my other host using http://www.mydomain.com

    Port 3306
     
  6. khiltd

    khiltd New Member

  7. marcm

    marcm Member

    That's possible but I was never using tunneling. I posted there and this is the reply Peter gave me:

    Peter Laursen of Webyog said:
    Makes sense to me. I guess the other host is stripping the prefix.
     
  8. khiltd

    khiltd New Member

    The client would be the one responsible for ignoring the URL scheme. Peter Laursen should brush up on both his English and TCP/IP.
     
  9. marcm

    marcm Member

    Ouch lol ..
     

Share This Page