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.

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.

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.

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

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/

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

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. :)

OpenOffice has a good database program.

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.

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

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?

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.