views:

294

answers:

7

I'm setting up my first development Linux box - a netbook actually. I'm quite fond of MySQL Yog for Windows, but that's not on linux.

I've checked these two threads What is the best free SQL GUI for Linux (MSSQL, MySQL, Oracle, Etc…) and Developer tools to directly access databases

I'm not interesting in something large and resource hungry (netbook) or that I have to pay for. Nor am I particularly interested in compatibility with SQL.

so, Can you recommend a free light-weight MySQL GUI for Linux?

Unless someone suggests something better I'll probably just go with phpMyAdmin.

Thanks, Dean.

+3  A: 

i suggest using phpmyadmin

it’s definitely the best free tool out there and it works on every system with php+mysql

knittl
A: 

Navicat MySQL version for Linux ( uses Wine ):

http://download.navicat.com/download/navicat8%5Flite%5Fen.tar.gz

meder
A: 

Why not try MySQL GUI Tools? It's light, and does its job well.

jpartogi
+3  A: 

I really like the MySQL collection of of GUI Tools. They aren't too large or resource hungry.

There are quite a few options here as well. Of the applications presented on that page, I like SQL Buddy - it does require a web server, however.

Nick Presta
I'm really liking SQL Buddy too. Unless I find myself needing to go back to phpmyadmin some time soon, you'll get the win.
Dean
+1  A: 

Here are few solutions -

  • MySql Gui tools is official ui from Mysql.
  • You can also try Mysql Workbench which is going to replace Gui Tools.
  • Mysql Yog can be run on Linux using wine (I think they officially recommend this method).
  • HeidiSql is also good option, I use it most of the time. It also run using wine on Linux. It lightest of all.
  • If you are looking for web based solution than phpmyadmin is the solution.

Since you are already using sqlyog, I suggest you to use same on Linux as well.

Sharique
+1  A: 

Try Adminer, whole application is in one PHP file. It's more powerful than phpMyAdmin, it can edit views, procedures, triggers, etc. You should definitely try it.

http://www.adminer.org/en/

tomp
+1  A: 

RazorSQL for Linux / Unix.

kboss