Remote connection to MySQL does not work with all ISPs

[mbsmt]

I've a MySQL 8.0 database on DA which is allowed to be used remotely. But I am only able to connect it remotely via some certain ISPs, others don't work and the connection fails.
This is the errors I receive: Lost connection to MySQL server during query
As I have static IPs, I am sure that the IPs are not blocked in firewall.

May you help me to solve this issue please?

 

[zEitEr]

Hello,

Anything useful in mysql error logs? Or system logs?

 

[sysdev]

Doe the queries have large resultsets of take a long time to compleet? Try increasing net_read_timeout, maybe also increase the connect_timeout and/or max_allowed_packet.

Check logs for more info.

 

[mbsmt]

Based on the paths in https://help.directadmin.com/item.php?id=11, there is not anything in system.log and also there is not any log file for mysql in server.
May you let me know is there anything required to have such logs?

 

[mbsmt]

Doe the queries have large resultsets of take a long time to compleet? Try increasing net_read_timeout, maybe also increase the connect_timeout and/or max_allowed_packet.

Check logs for more info.

Connecting sot MySQL is very fast by some ISPs, so the amount of packets should not be the cause of this problem in my mind.

 

[zEitEr]

How do you have the same static IP via different ISPs?

 

[mbsmt]

How do you have the same static IP via different ISPs?

I didn't say it anywhere!