2

I have a large (multi-gigabyte) SQL database on an external server. I can access it through SSH, but manually querying the data will be a major pain. I really need a GUI.

I'm using Ubuntu 13.04, but I can't find any applications with a GUI that'll allow me to do this. Can anybody recommend one?

4 Answers 4

1

I believe MySQL Workbench is what you're looking for.

2
  • this + the ssh tunnel option means no exposing of the mysql server
    – James
    Jun 28, 2013 at 6:44
  • Or use stunnel (stunnel.org), which will setup an encrypted session without requiring a shell login.
    – Jenny D
    Jun 28, 2013 at 6:47
2

Web interface: PHPMyAdmin - Bringing MySQL to the Web

2

Best I used are:

  1. MySQL Workbench
  2. SQuirreL SQL Client
  3. Emma
  4. TOra
  5. LibreOffice Base **needed to download mysql-jdbc-connector*
0

You can use SQLyog on wine in Ubuntu.

1
  • It's a paid thing isn't it? Jun 27, 2013 at 11:24

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.