Mysql remote connection is too slow

jenniferlopse

I set database permission to "everyone"

But sql query takes a lot of time from my "desktop localhost". It takes about 30second to load my php file contain mysql query.

When i set database permission as "specified IP" and enter my computer IPv4, But this time mysql connection error is shown.

I uninstalled sysfirewall, but no luck.

Can u please help me

aaPanel_Kern

jenniferlopse
Hello, permissions will not increase the speed, the speed depends on the sql statement you query, network speed, server performance.

jenniferlopse

aaPanel_Kern

My server has no performance issue. It already contain websites running fine.
I need to get the mysql database of that hosted website from my local computer.

My local computer has enough network speed.
Is there any limit set my aapanel??
Can u help me please...

aaPanel_Kern

jenniferlopse
Hello, aapanel does not limit any speed, this depends on the network environment, the size of the returned data, the execution time of mysql and other factors

jenniferlopse

aaPanel_Kern
Hii.
When i call the same mysql-query within server. It load fastly.
when i call the same mysql-query from my local computer it takes about 20second to load from server.

So is it normal to take about 20second for remote mysql call??
If it not normal can u please check my server. I can mail u my panel access.

aaPanel_Kern

jenniferlopse
What is the bandwidth of your server? What is your local network bandwidth?
What is the speed of downloading files locally from the server? What is the ip delay of pinging the server?
Is the amount of data you query large?
The query on the server does not need to be transmitted through the network, but the result is displayed directly