The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql - Remote connection

Discussion in 'General Discussion' started by DHL, Mar 20, 2002.

  1. DHL

    DHL Well-Known Member

    Joined:
    Mar 8, 2002
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    6
    Hi,

    I see this in CPanel news:-

    Mysql Access Hosts Users can not setup their mysql databases to be accessible from any host they choose (4.5.0 build 74 or later only)


    I have clients who need to connect to Mysql remotely with the mysql ODBC kit from mysql.com - How can I set them up to connect to Mysql remotely?

    Thanks

    Steve
     
  2. bdraco

    bdraco Guest

    [quote:26d071d542][i:26d071d542]Originally posted by DHL[/i:26d071d542]

    Hi,

    I see this in CPanel news:-

    Mysql Access Hosts Users can not setup their mysql databases to be accessible from any host they choose (4.5.0 build 74 or later only)


    I have clients who need to connect to Mysql remotely with the mysql ODBC kit from mysql.com - How can I set them up to connect to Mysql remotely?

    Thanks

    Steve[/quote:26d071d542]

    Just add the ip they are connecting from in their cpanel and they should be all set to go.
     
  3. DHL

    DHL Well-Known Member

    Joined:
    Mar 8, 2002
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    6
    Thanks I would do, but CPanel is inaccessable this morning after then scheduled updates - The login @:2082 gives a blank page :-(

    Steve
     
  4. DHL

    DHL Well-Known Member

    Joined:
    Mar 8, 2002
    Messages:
    88
    Likes Received:
    0
    Trophy Points:
    6
    With it!

    Updated CPanel manually and can see where to put the IP now,

    Cheers, sorry for being dim :)

    Steve
     
  5. n2nis

    n2nis Active Member

    Joined:
    Aug 16, 2001
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Anyone Get This To Work

    I have tried but mysql keeps denying access. I checked my users database and found the new hosts in there. Does anyone know if being behind a firewall could cause my access to be denied? I don't think that is the problem but that is the only solution I can think of.
     
  6. n2nis

    n2nis Active Member

    Joined:
    Aug 16, 2001
    Messages:
    42
    Likes Received:
    0
    Trophy Points:
    6
    Skip That

    I figured it out, Thanks...
     
  7. payne

    payne Well-Known Member

    Joined:
    May 31, 2003
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Seattle
    What was the problem? I am having the same problem... add the ip but still can't get access.

    cPanel.net Support Ticket Number:
     
  8. redbox

    redbox Registered

    Joined:
    Nov 8, 2002
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    I'm having the same problem. Any solution?
     
  9. payne

    payne Well-Known Member

    Joined:
    May 31, 2003
    Messages:
    103
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Seattle
    Well... my problem was that I failed to use the username and password set in the mysql cpanel section... I tried to use the un/pw of my cpanel account... too much coffee or something.
     
  10. antoshka

    antoshka Member

    Joined:
    Oct 27, 2003
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    i have the same problem... n2nis, why couldn't you just post your solution??
     
Loading...

Share This Page