0

I want to connect to a mysql database located on a linux server, through ssh and using private key and a passphrase, from windows 10, I'm looking for a GUI mysql viewer.

  • PHPmyadmin won't work in such scenario
  • Mysql workbench didn't work, it couldn't connect using a private key for some reason, it has that option but did not work.
  • DataGrip works but it's so confusing, I don't know how to use it, to the point that if I need to do something, I'd rather SSH to the server and write SQL

I want something that:

  • is free, I'm willing to pay if the software is decent though and the price is reasonable (around $50 max, might stretch the budget a bit, and one time purchase)
  • As easy to use as SequelPro which is for mac only , notice how clean the user interface is, notice how you rarely need to type any sql command, which is not the case for datagrip, at least I wasn't able to use it
  • Good documentation or/and tutorials, if I get stuck on datagrip I rarely find help
  • Should be able to connect through ssh using a private key and a passphrase
  • The software should be similar to PHPMyadmin and When I login, the databases should be listed on the left, when I click a database, tables should be listed
  • Extra point: decent community, preferably on stackoverflow

Dbvis is too expensive, I'm going to try HeidiSQL and see if it works, I want to know what other options do I have? Because it seems that HeidiSQL is my only option now.

Edit: Heidisql is prompting me to enter my passphrase but there's no input field, so I can't connect, unless this bug can be fixed, I'll have to find another software.

  • +1 HeidiSQL indeed a wise choice – Josem Oct 1 '18 at 20:06
  • @Josem Heidisql is prompting me to enter my passphrase but there's no input field, so I can't connect, unless this bug can be fixed, I'll have to find another software. – Lynob Oct 1 '18 at 21:02
  • when are you requested to enter the passphrase? – Josem Oct 2 '18 at 8:05
  • @Josem after pressing "open" it tries to connect to the server but I get imgur.com/a/kMXBzm3 and there's no input field to enter my passphrase. there's only the okay button – Lynob Oct 2 '18 at 8:14
  • Connect using your key and set up a tunnel - do this with Putty.exe - then connect to the SQL server using MySQL Workbench in the normal manner, specifying localhost and whatever port you are forwarding... – ivanivan Oct 2 '18 at 17:58
0

I ended up using DBeaver free edition, it has pretty much all I asked for. If anyone has a better answer, I'll accept his answer.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.