Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
add comment

4 Answers

up vote 0 down vote accepted

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

share|improve this answer
    
this + the ssh tunnel option means no exposing of the mysql server –  James Jun 28 '13 at 6:44
    
Or use stunnel (stunnel.org), which will setup an encrypted session without requiring a shell login. –  Jenny D Jun 28 '13 at 6:47
add comment

Web interface: PHPMyAdmin - Bringing MySQL to the Web

share|improve this answer
add comment

Best I used are:

  1. MySQL Workbench
  2. SQuirreL SQL Client
  3. Emma
  4. TOra
  5. LibreOffice Base *needed to download mysql-jdbc-connector
share|improve this answer
add comment

You can use SQLyog on wine in Ubuntu.

share|improve this answer
    
It's a paid thing isn't it? –  Todd Davies Jun 27 '13 at 11:24
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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