Easy GUI editor for Mysql

Post by **Patrick** » Tue Mar 07, 2006 10:32 am

I've started working on a project that will involve LAMP. I've used the MySQL Adminstrator program to define my database. Very nice tool. Now I want to insert some rows in my table with something quick and dirty. I don't want to manually issue sql commands on the command line. This gets very tedious. I tried using OO Base and connecting to my database with ODBC. I can connect to the database and view my records but can't edit them. Apparently this is an OO bug. So I've downloaded the trial version of Navicat. It works ok but it's very ugly and not very intuitive. It also doesn't support cut & paste from other apps. You also have to pay after the 30 day trial. Does anyone have a recommendation for GUI to MySQL that I can use to create some records in my database that won't cost anything? If this project works out it could lead to more linux at my job.

Karl · Post by **Karl** » Tue Mar 07, 2006 11:23 am

phpMyAdmin should work for that.

http://www.phpmyadmin.net/

Linc · Post by **Linc** » Tue Mar 07, 2006 12:03 pm

Karl wrote:phpMyAdmin should work for that.

http://www.phpmyadmin.net/

Yeah, i second that. or perhaps turboadmin, but I don't know how far they have come with that yet. when I looked at it a few months ago i thought it was pretty cool.

http://turboajax.com/turbodbadmin.html

Post by **Patrick** » Tue Mar 07, 2006 2:10 pm

Linc wrote: http://turboajax.com/turbodbadmin.html

I can't do a apt-get install for phpadmin because they've got port 21 blocked around here so I went and installed turboadmin.
Very nice. Easy to install and work with.
Thanks

Now to start coding some php scripts.

Jza · Post by **Jza** » Tue Mar 07, 2006 6:49 pm

phpmyadmin is a web app so installing a binary is just an overkill IMO the onlything to do with webapps is unzip on your Documentroot (the filder that gets broadcasted) and edit the config file. unless the webapp has a web-config too.

PHPMyAdmin can be administrate by just editing the config. The problem you have with OOoBASE has to do with the permissions and changing a configuration in the MySQL system.Then you will be able to edit also, is documented under http://dba.openoffice.org BTW I recomend using JDBC as opposed to ODBC on Linux, is more straight forward.

Finally there are other MySQL useful programs provided by MySQL as FLOSS such as MySQLCC MySQL-Administrator and a Mysql migration tool to port from Access or Oracle database into mysql.

MySQL Migration Toolkit.

Jza · Post by **Jza** » Wed Mar 08, 2006 9:45 pm

http://dba.openoffice.org/howto/IgnoreD ... leges.html

Read/Write access rights (privileges) for JDBC/ODBC data sources
The Problem
When working with drivers which not fully support the access to the privileges of the database or returning just incorect information, OpenOffice.org only allows the operations which the driver returns. E.g. when the driver doesn't return the right to insert values into a table even when the database allows it, OpenOffice.org also shows the table in read only mode.
The Solution
The OpenOffice.org JDBC/ODBC-SDBC bridge (more sloppy: OOo's JDBC/ODBC driver) supports to work around the problem in just to return that all rigths are granted, the sytem driver won't be asked in that case.