Conecting mysql remotely?

Discussion in 'MySQL' started by Alvin, Apr 30, 2007.

0
  1. #1
    Hello friends,

    I have trouble connecting MySQL hosted at other host....

    Here is what I am trying to do...

    conect to mysql from host A to host B..

    these are the settigns I am using..

    host- Ip address of host B
    DB username: xxxxxxx
    DB name: YYYYYYY
    DB password: *******

    I am using cPanel on both hosts and yes I have given permissons to access database from host A i.e added host A's ip...

    can you please tell me what I am missing here....?

    I am getting connection error:confused:
     
    Alvin, Apr 30, 2007 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,839
    Likes Received:
    4,542
    Best Answers:
    123
    Trophy Points:
    665
    #2
    Chances are that your webhost has setup MySQL to only accept requests from a certain IP range = and that doesn't include the second site.

    Install Toad (see http://forums.digitalpoint.com/showthread.php?t=316254) and try to connect through that. It'll give you a user friendly error message if I'm right.
     
    sarahk, Apr 30, 2007 IP
  3. Alvin

    Alvin Notable Member

    Messages:
    2,076
    Likes Received:
    164
    Best Answers:
    0
    Trophy Points:
    210
    #3
    Let me give i a try..

    BUT I am sure that I have added this IP in cPanel to allow that IP to connect which should work fine (theoretically)

    Anyway thanks for the reply....
     
    Alvin, Apr 30, 2007 IP
  4. yourihost

    yourihost Well-Known Member

    Messages:
    1,708
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    115
    #4
    For the hostname try the domain of the host.
     
    yourihost, Apr 30, 2007 IP
  5. cyanide

    cyanide Peon

    Messages:
    483
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Yes, you may have to put the hostname of the server and/or the ip address of the server, not just the ip of domain A.
     
    cyanide, Apr 30, 2007 IP
  6. Alvin

    Alvin Notable Member

    Messages:
    2,076
    Likes Received:
    164
    Best Answers:
    0
    Trophy Points:
    210
    #6
    This is what had happend.. my site was on dedicated ip and I was using dedicated IP... it needs shared ip of the host....
     
    Alvin, Apr 30, 2007 IP
  7. cyanide

    cyanide Peon

    Messages:
    483
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #7
    So, it's working for you now?
     
    cyanide, May 4, 2007 IP
  8. Alvin

    Alvin Notable Member

    Messages:
    2,076
    Likes Received:
    164
    Best Answers:
    0
    Trophy Points:
    210
    #8
    Yeah! I was adding wrong IP.
    But its working fine now.
     
    Alvin, May 4, 2007 IP