Tag Archives: navicat

Access MySQL server over SSH tunnel using Navicat

Today was my first time to access a MySQL server over a SSH tunnel in Navicat. After a bit of trial and error I was finally able to achieve success 🙂 Here are the main things I learned: #1 On the client machine running Navicat, use the same credentials that you would use if you were at the console of the remote server. In this case localhost and port 3306 #2 On the SSH tab, use the remote server’s IP

[Err] 2006 – MySQL server has gone away Navicat/WordPress [solved]

Recently I tried upgrading to the latest version of the WordPress Download Monitor plugin. It did not go well 🙁 Thus, I tried to revert from a backup made using Navicat. Unfortunately, the restore would fail every time while trying to import my wp_posts table (a pretty important table!) I tried exporting the backup to a SQL dump and importing that. No luck. Finally, I tried resolving the actual ‘MySQL server has gone away’ issue itself and I had success. This tip