LinuxQuestions.org
Go Job Hunting at the LQ Job Marketplace
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
LinkBack Search this Thread
Old 01-01-2006, 07:02 PM   #1
apachedude
Member
 
Registered: Aug 2004
Location: California
Distribution: SuSE 10.0 (SUPER)
Posts: 356

Rep: Reputation: 31
Need database program to access MySQL


OpenOffice.org Base is absolute crap. It seems as though OO.o rushed it out of production. It wouldn't connect to my MySQL server until I tried several different versions of JRE to get it to work. The most routine things like adding records to fields are painful or impossible to do for a new user. The GUI needs a facelift.

Is there any alternative? I would use Access, but I removed Windows and CrossOver Office doesn't support it. I'm contemplating switching back to Windows, and I've been running only Linux for over a year now. I can't believe how lacking OSS is in terms of a usable database program.
 
Old 01-01-2006, 07:31 PM   #2
ssfrstlstnm
Member
 
Registered: Dec 2004
Location: IN, USA
Distribution: debian etch
Posts: 402

Rep: Reputation: 30
Check out http://www.sqlyog.com

It is commercial software, but I think there is a free version for linux. It has a very nice interface and some tools for migrating databases.

Phpmyadmin is also fairly good.

And of course there is mysqladmin and mysql query browser from http://www.mysql.com. But I have found these to be not very good.
 
Old 01-01-2006, 07:33 PM   #3
apachedude
Member
 
Registered: Aug 2004
Location: California
Distribution: SuSE 10.0 (SUPER)
Posts: 356

Original Poster
Rep: Reputation: 31
Thanks. My original post looks like a bit of a rant against OO.o, and I apologize for that. It was quite frustrating to use.
 
Old 01-01-2006, 11:05 PM   #4
shoekstr
LQ Newbie
 
Registered: Aug 2003
Distribution: Gentoo, Debian, Slackware
Posts: 22

Rep: Reputation: 15
have you tried phpmyadmin? It will run of apache and php I like it

i have also used the command line mysql interperter which is mysql in the terminal.

last but not least there was mysql control center i havent' used that in a while
 
Old 01-02-2006, 02:12 AM   #5
wykthorr
Member
 
Registered: Oct 2004
Location: Brasov, Romania
Distribution: Ubuntu
Posts: 38

Rep: Reputation: 15
Try the MySQL Query Browser for linux. It's built by MySQL AB. It has a lot of features including exporting resultsets, loading and running scripts.
As a complement to this you might want to use MySQL Administrator. You can use it for backup and database administration.
They are both avaliable for free download at http://dev.mysql.com/downloads/
 
Old 01-02-2006, 05:07 AM   #6
frankmulder
Member
 
Registered: Jun 2004
Distribution: Kubuntu
Posts: 30

Rep: Reputation: 15
I personally found Knoda (http://www.knoda.org/) a very useful program. It is of course not as mature as Access (like all other Linux database programs), but it was good enough for me.

You can also try Rekall, which is now available under GPL license. See http://www.rekallrevealed.org.

Have fun!

Frank
 
Old 01-02-2006, 05:34 AM   #7
Guttorm
Senior Member
 
Registered: Dec 2003
Location: Trondheim, Norway
Distribution: Debian and Ubuntu
Posts: 1,089

Rep: Reputation: 207Reputation: 207Reputation: 207
Hi

The best program i've seen is NaviCat from www.navicat.com.

It costs $$$ but not terribly much and there's an evaluation version.

Finally a decent Access alternative available for Linux.
 
Old 01-02-2006, 08:39 AM   #8
igor segec
LQ Newbie
 
Registered: Mar 2005
Posts: 2

Rep: Reputation: 0
OpenOffice has a good database program.
 
Old 01-02-2006, 03:08 PM   #9
sundialsvcs
Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 5,042

Rep: Reputation: 952Reputation: 952Reputation: 952Reputation: 952Reputation: 952Reputation: 952Reputation: 952Reputation: 952
I'm definitely looking for a really-good database access program, on par with Microsoft Access or Paradox for Windows, which runs native. I see no reason why such a thing should be hard to find, and paying money for it doesn't bother me.
 
Old 01-02-2006, 08:19 PM   #10
apachedude
Member
 
Registered: Aug 2004
Location: California
Distribution: SuSE 10.0 (SUPER)
Posts: 356

Original Poster
Rep: Reputation: 31
Quote:
Originally Posted by frankmulder
I personally found Knoda (http://www.knoda.org/) a very useful program. It is of course not as mature as Access (like all other Linux database programs), but it was good enough for me.

You can also try Rekall, which is now available under GPL license. See http://www.rekallrevealed.org.

Have fun!

Frank
I tried KNoda first, but I get can't get it to connect to MySQL databases. I have the same exact problem as this guy: http://lists.opensuse.org/archive/op...-Oct/0017.html
 
Old 01-03-2006, 09:34 AM   #11
SAFX
Member
 
Registered: Oct 2004
Location: New York City
Distribution: Mandrake 10.1 CE
Posts: 35

Rep: Reputation: 15
Quote:
Originally Posted by apachedude
I tried KNoda first, but I get can't get it to connect to MySQL databases. I have the same exact problem as this guy: http://lists.opensuse.org/archive/op...-Oct/0017.html
The error indicates the database drivers (.so) are not available in that directory. Did you check?

SAFX
 
Old 01-03-2006, 10:36 AM   #12
Dragineez
Member
 
Registered: Oct 2005
Location: Annapolis
Distribution: Ubuntu
Posts: 275

Rep: Reputation: 32
My Vote

I cast my vote for phpmyadmin as well. I can see the utility of a file based DB, but phpmyadmin works so well. Access and myodbc work also. But you already said you didn't have a Windows machine anymore, didn't you?
 
Old 01-03-2006, 10:50 AM   #13
notorp
LQ Newbie
 
Registered: Sep 2005
Distribution: Fedora 10/9/8/6 - FC3 - RH9 + Puppy Dog
Posts: 27

Rep: Reputation: 15
I like mysqlcc finding a copy is tricky now since mysql-query and admin tools exist as no one maintains it. Mine version still works under FC4/FC3 and RH9. The windows version also still work.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
C++ program to access mysql ? SQLAPI++ ?? Bluesuperman Programming 3 06-30-2005 08:56 PM
How to interact with MYSQL database from within perl program Bassam Programming 5 02-26-2004 05:00 PM
Restoring MYSQL database without SSH shell access hct224 Linux - Newbie 5 01-08-2004 06:14 AM
MySQL on RedHat 9 GUI, can't access database linuxquestionsu Linux - Software 0 10-09-2003 02:44 PM
MySQL Cannot Access Database ChineseElite Linux - General 13 11-27-2002 08:30 PM


All times are GMT -5. The time now is 04:50 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration