[SOLVED] mysql browser/editor

qrange · 06-14-2011, 05:25 AM

I need some simple "editor" mysql client, that will allow me to easily add new rows to existing tables or change them.
I wish it to be with nice GUI and similar to Excel/Access, not some query commands.

does such thing exist in repository?

thanks.

druuna · 06-14-2011, 05:33 AM

Hi,

phpmyadmin comes to mind, a web based tool. It is included in the Debian repository.

Hope this helps.

qrange · 06-14-2011, 06:01 AM

wait, that requires running web server? if so, its unacceptable.
thanks.

smoker · 06-14-2011, 06:35 AM

http://mysql.com/products/workbench/

qrange · 06-14-2011, 06:53 AM

@smoker
yeah, I tried that in meantime. ubuntu 64bit version installs fine on Debian after resolving few dependencies.
But there doesn't seem to be userfriendly way to edit data. its more usable for creating database structure, which I don't need at all.

problem solved with wine+heidiSQL

/rant
such a shame linux programers often don't make proper GUI but give us that web-gui and similar cr@p.

smoker · 06-14-2011, 07:00 AM

Let's just hope you don't come up against a problem you can't solve because the windows programmers have made the software "user friendly" !
mySQL is supposed to be a networked database, access isn't. Maybe you can see why the GUIs are different. If you can't understand enough sql to write your own queries, a nice GUI is not going to help you do a good job.

qrange · 06-14-2011, 07:13 AM

perhaps. but all I need is to change few rows. it shouldn't be a "rocket science" and I have no time/will to learn sql. there are more important things to do atm.
this database has only one user. and it runs on only one computer.

almatic · 06-14-2011, 01:50 PM

although you have marked this thread solved I'm a bit puzzled about your solution.
There's mysql-gui-tools for example, or tora and there's of course the base plugin for libreoffice which allows you to modify mysql databases from within libreoffice.
Did you really not find these or do they not suit your needs ?

qrange · 06-14-2011, 05:24 PM

heidi is the first one I found. anything not requiring wine is welcome (there are some error messages with heidi).
will try them, thanks.

qrange · 06-15-2011, 01:17 AM

@almatic
well I tried all three.
'mysql-gui-tools' is the same as 'mysql query browser' and it doesn't meet my requirements (tried that one long time ago). same goes for tora. I want Excel type interface.
as for libreoffice plugin, it gives some errors on install. I tried both ODBC and JDBC in LibreOffice_Base but it failed. (is that plugin using some other connectivity?)

sigh.

almatic · 06-15-2011, 01:43 AM

so how about emma ?
looks pretty excelish to me

edit: if you use odbc of jdbc you don't need the plugin.

qrange · 06-15-2011, 08:07 AM

hm, emma is good. I think heidi would be slightly better, if it weren't for wine requirement. (heh, its similar with some women..)
tough choice.

thanks.