Remote MySQL connections slow

G

Gareth-AWD

Well-Known Member
Jul 3, 2008
195
13
68
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?
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
L MYSQL remote connections Databases 3
S Force SSL on remote MySQL connections Databases 3
R PHP: Remote MySQL connections very slow Databases 2
K Do you allow remote connections on mysql? Databases 3
C Problems with remote mysql: too many connections Databases 1
Similar threads
MYSQL remote connections
Force SSL on remote MySQL connections
PHP: Remote MySQL connections very slow
Do you allow remote connections on mysql?
Problems with remote mysql: too many connections
Top Bottom