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.

Remote MySQL connections slow

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

  1. Gareth-AWD

    Gareth-AWD Well-Known Member

    Joined:
    Jul 3, 2008
    Messages:
    144
    Likes Received:
    2
    Trophy Points:
    18
    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:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page