TablePlus icon indicating copy to clipboard operation
TablePlus copied to clipboard

Connection issues

Open HassoEccard opened this issue 3 years ago • 6 comments

Please answer the questions below, it helps us to keep track of the issue. Please do not ignore it or your issue will be closed.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): MySQL 5.7

  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): 454

  3. The steps to reproduce this issue: I'm connecting to a shared database @ Siteground. It's been fine for more than a year, and suddenly yesterday I started getting "Lost connection to MySQL server at 'waiting for initial communication packet', system error: 60" when connecting. If I delete the program (just the program) and reinstall it, then it connects perfectly the first time, but after that I get this error. It works fine connecting to Aurora MySQL @ AWS. Deleting the program and the data, then reinstalling, doesn't alter the problem. I've had Siteground check the firewalls, and there's no block. I've tried going in on alternate IPs (confirming remote access etc) and it makes no difference. From the same machine, I can connect using another MySQL client.

Noted: If the bug is related to data, please attach an example SQL data.

HassoEccard avatar Oct 05 '22 17:10 HassoEccard

Hi @HassoEccard have you tried to restart macOS? I think there is an error in the macOS that blocks connections from TablePlus?

huyphams avatar Oct 06 '22 13:10 huyphams

Thanks for the reply - it was the first thing I did, then again after various other changes. I'll look into anything 'inside' the mc that might be causing it.

HassoEccard avatar Oct 07 '22 08:10 HassoEccard

I have had the same issue - it was caused by the AllowTcpForwarding option in /etc/ssh/sshd_config file on the server

jakub-zawislak avatar Dec 15 '22 10:12 jakub-zawislak

I encountered the same problem. When I try to connect to the database using TablePlus, I get the error message: "Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 60." However, I can use other database connection software like Sequel Pro or Navicat without any issues.

BinaryAlan avatar Nov 07 '23 09:11 BinaryAlan

Hi @BinaryAlan could you show me the connection config screenshot to [email protected] Thanks

huyphams avatar Nov 07 '23 13:11 huyphams

Any update on this issue? A colleague of mine is getting this issue even though we have mimicked the exact setup and config on multiple other machines with no issues..

gus-t27 avatar Apr 17 '24 21:04 gus-t27