I have a WordPress site hosted in Kinsta.
I'm trying to connect to its MySQL database remotely from PhpStorm using SSH.
The SSH connection is connected successfully, but when I try to connect to the main DB, I get the following error:
[08S01]
Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
I tried contacting Kinsta Support but they don't have any proper answer for this.
Please Note: If I connect to the same DB from MySQL Workbench, it works fine. This is only when I connect from PhpStorm!
Can anybody please help me?