[opensuse] MySQL GUI frontends

newer
[opensuse] Encrypted Root Partition

older
[opensuse] Yast Software Install...

Bob

23 Dec 2007 23 Dec '07

22:23

I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions? Happy Christmas :) -- Bob openSUSE 10.3, Kernel 2.6.22.13-0.3-default, KDE 3.5.8 Intel Celeron 2.53GB, 2GB DDR RAM, nVidia GeForce 7600GS -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Show replies by date

Carlos E. R.

23 Dec 23 Dec

23:12

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Sunday 2007-12-23 at 22:23 -0000, Bob wrote:

...

I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

rekall - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHbut0tTMYHG2NR9URAk7mAJ9SqalGYXI1rFmouxivgn0I+9cBywCgg6dm Az9vNNdbX3KAFs/m0lG/f9k= =4EhH -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Aaron Kulkis

24 Dec 24 Dec

01:42

Carlos E. R. wrote:

...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

The Sunday 2007-12-23 at 22:23 -0000, Bob wrote:

...
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

rekall

I think it's pretty funny how that name can conceivably be pronounced as either "recall" or "wreck-all" -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Bob

26 Dec 26 Dec

10:52

On Sunday 23 December 2007 23:12:50 Carlos E. R. wrote:

...

The Sunday 2007-12-23 at 22:23 -0000, Bob wrote:

...
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

rekall

Thanks. Rekall seems to fit the bill, and is easy to set up. I'd previously tried OOo Base, but it seemed to want to recreate the database in .odb format, whereas Rekall is using the same MySQL tables, so I can administer the database from the command line or through the Rekall GUI. Knoda seemed to have the same problem as Base. Thanks to everyone for all the other suggestions. Happy New Year :) -- Bob openSUSE 10.3, Kernel 2.6.22.13-0.3-default, KDE 3.5.8 Intel Celeron 2.53GB, 2GB DDR RAM, nVidia GeForce 7600GS -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Carlos E. R.

20:31

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Wednesday 2007-12-26 at 10:52 -0000, Bob wrote:

...

...
rekall

Thanks. Rekall seems to fit the bill, and is easy to set up. I'd previously tried OOo Base, but it seemed to want to recreate the database in .odb format, whereas Rekall is using the same MySQL tables, so I can administer the database from the command line or through the Rekall GUI. Knoda seemed to have the same problem as Base.

Thanks to everyone for all the other suggestions.

OOo should be able to connect to an existing database, although setting up OOo to use mysql (or any other engine) is far from trivial. Knoda I haven't been lucky using it. In previous versions it crashed or didn't display what I wanted, etc, etc. Rekall has a fast and very easy to use interface, either for database design or use; plus you can use it with mysql, postgres, etc. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHcroOtTMYHG2NR9URAscUAJ4mTOoiOv0QAaTsmdgdJTc+GV19oQCeMKZh ZoE4xbnS/tB/NFC2APiHZUQ= =heEQ -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Pete Connolly

23 Dec 23 Dec

23:13

Bob wrote:

...

I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

Happy Christmas :)

Good evening Bob, You could do worse than looking at either phpmyadmin - http://www.phpmyadmin.net/home_page/index.php or MySQL Administrator - http://dev.mysql.com/downloads/gui-tools/5.0.html I tend to use phpmyadmin on my remote servers, with a strong password and an obscured path. Mysql administrator is good for workstation work locally where I have a GUI. Have a look at both and see what you prefer. Have a great Christmas and a happy new year. :) Cheers Pete -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Kai Ponte

23:21

On Sunday 23 December 2007 14:23, Bob wrote:

...

I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

Several: I use most often - since there's very little install - phpMySQL. It comes with openSUSE and runs in Apache. There's also the MySQL Administrator. Both of those come with openSUSE and can be loaded via YaST or SMART or whatever you tool of choice is. I've had good luck with the MySQL tools as well: http://dev.mysql.com/downloads/gui-tools/5.0.html HTH! -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Anders Johansson

23:27

On Sunday 23 December 2007 23:23:58 Bob wrote:

...

I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

tora is quite popular http://tora.sourceforge.net Anders -- Madness takes its toll -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Joe Sloan

23:48

Anders Johansson wrote:

...

On Sunday 23 December 2007 23:23:58 Bob wrote:

...
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

tora is quite popular

http://tora.sourceforge.net

Great for oracle, but useless for mysql or any other rdbms last I checked - or have they done an extreme makeover on it? Joe -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Anders Johansson

23:55

On Monday 24 December 2007 00:48:17 Joe Sloan wrote:

...

Anders Johansson wrote:

...
On Sunday 23 December 2007 23:23:58 Bob wrote:

...
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

tora is quite popular

http://tora.sourceforge.net

Great for oracle, but useless for mysql or any other rdbms last I checked - or have they done an extreme makeover on it?

I've used it with mysql. Admittedly, I'm not really a DBA, so I haven't used it for much more than simple stuff, but it seems to work well enough for that. I know it was written for Oracle, but it does work with mysql. But as I said, I'm no DBA, so I'm not a good judge of what's great or not Anders -- Madness takes its toll -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Kai Ponte

24 Dec 24 Dec

00:10

On Sunday 23 December 2007 15:48, Joe Sloan wrote:

...

Anders Johansson wrote:

...
On Sunday 23 December 2007 23:23:58 Bob wrote:

...
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

tora is quite popular

http://tora.sourceforge.net

Great for oracle, but useless for mysql or any other rdbms last I checked - or have they done an extreme makeover on it?

I'm trying to install but it wants to have me download a "basic" package that is only availble through a registered login at the oracle site.... -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Donald D Henson

10:21

Bob wrote:

...

I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

Happy Christmas :)

Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.) Don Henson -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Kai Ponte

15:39

On Monday 24 December 2007 02:21, Donald D Henson wrote:

...

Bob wrote:

...
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

Happy Christmas :)

Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.)

That looks great, but.... ...how does on install VS2005 in Linux? :P -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Tom Patton

21:26

On Mon, 2007-12-24 at 03:21 -0700, Donald D Henson wrote:

...

Bob wrote:

...
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

Happy Christmas :)

Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.)

Don Henson

I'd like to check it out...but their site only has a windoz version, no LINUX until 2008... Tom in NM -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Sunny

25 Dec 25 Dec

14:27

On Dec 24, 2007 3:26 PM, Tom Patton wrote:

...

...
Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.)

Don Henson

I'd like to check it out...but their site only has a windoz version, no LINUX until 2008...

Tom in NM

Check for package mysql-gui-tools on download.opensuse.org. It contains mysql-admin, mysql-query-browser, and ... mysql-workbenck Cheers -- Svetoslav Milenov (Sunny) Even the most advanced equipment in the hands of the ignorant is just a pile of scrap. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Tom Patton

17:09

On Tue, 2007-12-25 at 08:27 -0600, Sunny wrote:

...

On Dec 24, 2007 3:26 PM, Tom Patton wrote:

...
...
Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.)

Don Henson

I'd like to check it out...but their site only has a windoz version, no LINUX until 2008...

Tom in NM

Check for package mysql-gui-tools on download.opensuse.org.

It contains mysql-admin, mysql-query-browser, and ... mysql-workbenck

Cheers

-- Svetoslav Milenov (Sunny) Thanks, Sunny, I had overlooked the workbench when installing from the dvd's, I thought it was the "benchmark"...it is a separate rpm "mysql-workbench" on the dvd.

It installed 1.1.10alpha, and indeed looks very promising. I'll look some more for the beta version. Merry Christmas...or whatever is appropriate for you. Thanks! Tom -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Kai Ponte

26 Dec 26 Dec

06:09

On Tuesday 25 December 2007 06:27, Sunny wrote:

...

On Dec 24, 2007 3:26 PM, Tom Patton wrote:

...
...
Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.)

Don Henson

I'd like to check it out...but their site only has a windoz version, no LINUX until 2008...

Tom in NM

Check for package mysql-gui-tools on download.opensuse.org.

It contains mysql-admin, mysql-query-browser, and ... mysql-workbenck

I have that installed - but there's no query browser or workbench that I can see. How do I run them? OT - i wish the RPM database showed what the executable(s) for an application or package was. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Jerry Houston

07:46

Kai Ponte wrote:

...

I have that installed - but there's no query browser or workbench that I can see.

How do I run them?

Mine showed up as 'Database Query Tool' in 'New Applications.'

...

OT - i wish the RPM database showed what the executable(s) for an application or package was.

Use the YaST software installation module, and it will list the files that are part of a package, and where they are placed on your system. Some of them display in bold type -- I'm guessing those are the executables. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Carlos E. R.

10:59

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Tuesday 2007-12-25 at 23:46 -0800, Jerry Houston wrote:

...

...
OT - i wish the RPM database showed what the executable(s) for an application or package was.

Use the YaST software installation module, and it will list the files that are part of a package, and where they are placed on your system. Some of them display in bold type -- I'm guessing those are the executables.

Only after they are installed. Or, you can use "pin", which will show them "before" and "after". - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHcjQNtTMYHG2NR9URAlBSAJwLIRIOayWbL9rAMvEgPJ6F41ONbwCeKAYb kDogQW44Y1WevGIzaat2SAs= =Xv0M -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Kai Ponte

13:51

On Tuesday 25 December 2007 23:46, Jerry Houston wrote:

...

Kai Ponte wrote:

...
I have that installed - but there's no query browser or workbench that I can see.

How do I run them?

Mine showed up as 'Database Query Tool' in 'New Applications.'

ahh, new applications - that is very nice. Actually another post clued me in. Turns out there is a seperate mysql-queryworkbench rpm to install.

...

...
OT - i wish the RPM database showed what the executable(s) for an application or package was.

Use the YaST software installation module, and it will list the files that are part of a package, and where they are placed on your system. Some of them display in bold type -- I'm guessing those are the executables.

Bold. Got it. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Carlos E. R.

28 Dec 28 Dec

11:39

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Tuesday 2007-12-25 at 08:27 -0600, Sunny wrote:

...

Check for package mysql-gui-tools on download.opensuse.org.

It contains mysql-admin, mysql-query-browser, and ... mysql-workbenck

They are separate packages now. ] mysql-workbench - A MySQL visual modeling tool ] ] MySQL Workbench is modeling tool that allows you to design and generate ] MySQL databases graphically. ] MySQL Workbench requires OpenGL and a 3D accelerated graphics card with ] at least 16MB of memory. Why does it need that? It is the first time I see an "office" tool needing heavy graphic resources :-O :-/ - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHdOBltTMYHG2NR9URAkFaAKCUKZEpOIM42VMCYN1SxtjuJR9RvgCfWXjr HkCWUY2iOOpf7+Lze4oBhEs= =z4oc -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Ritchie Fraser

24 Dec 24 Dec

10:47

On Sunday 23 December 2007 22:23:58 Bob wrote:

...

I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

Hi Bob I have used phpMyAdmin and knoda and found both to be acceptable Merry Christmas -- Kind Regards, Ritchie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ritchie Fraser Web: http://www.rpfraser.uklinux.net Registered Linux User #255860

Jason Craig

25 Dec 25 Dec

20:30

Bob wrote:

...

I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

Happy Christmas :)

Also, if you use Eclipse already for anything I know I have tools installed for MySQL and databases in general. Can't remember if they are plugins or came with the platform SDK. I can look let you know if you are interested. Merry Holidays --Jason -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

Michael Fischer

27 Dec 27 Dec

06:06

On Sun, Dec 23, Bob wrote:

...

I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?

sqldeveloper from oracle, dbvis (google it). You'll need to find and install the java mysql code, usually called mysql-connector-java-X.X.X.tar.gz for either of the above. sqldeveloper seems more powerful generally, but dbvis has a nifty graph view based on foreign keys. Nice to see what depends on what. Michael "who has never been able to build a mysql gui pkg from mysql" -- Michael Fischer michael@visv.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org

5973

Age (days ago)

5978

Last active (days ago)

List overview

Download

23 comments

14 participants

participants (14)

Aaron Kulkis
Anders Johansson
Bob
Carlos E. R.
Donald D Henson
Jason Craig
Jerry Houston
Joe Sloan
Kai Ponte
Michael Fischer
Pete Connolly
Ritchie Fraser
Sunny
Tom Patton