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 connections slow

Discussion in 'Database Discussion' started by Gareth-AWD, Feb 4, 2016.

  1. Gareth-AWD

    Gareth-AWD Well-Known Member

    Joined:
    Jul 3, 2008
    Messages:
    170
    Likes Received:
    4
    Trophy Points:
    68
    Location:
    London, UK
    cPanel Access Level:
    Root Administrator
    I'm having a problem with remote MySQL connections. I set up the local IP to access it but a page load takes about 5 seconds before you see it. If I run the php files on the server it's lightening fast.

    I've changed the my.cnf to skip-name-resolve as I heard that causes issues, but still it's slow. I also put my SQL connection to the IP as well as the server.domain.com but still the same.

    Any ideas?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,738
    Likes Received:
    1,796
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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