Remote MySQL connections slow


Well-Known Member
Jul 3, 2008
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 but still the same.

Any ideas?