Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Remote MySQL connection problem

Discussion in 'General Discussion' started by ialex03, Sep 17, 2003.

  1. ialex03

    ialex03 Well-Known Member

    May 15, 2003
    Likes Received:
    Trophy Points:

    I hope somebody can help me.

    A customer wants to connect to mysql at our server via ODBC from his own computer.
    Here is his sessions log:

    His IP is added to "allowed hosts", also I do can connect from my computer without a problem.
    Can somebody point me to where I can start to track the problem from?

    Thank you. Support Ticket Number:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. rsaylor

    rsaylor Well-Known Member

    Mar 27, 2003
    Likes Received:
    Trophy Points:
    I was having a simular problem.

    1. I wanted to connect to a remote MySQL database from another server.

    2. I did not want to have to keep entering IP's as multiple servers would connect.

    Goto cPanel for the user that hosts the DB.

    In the add host input "%" and save. Now, all remote servers should be able to connect to your IP address instead of using localhost

    Hope this helps for somebody, I searched and never found this info so here it is.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice