Is there a "best" tool for exposing MySQL tables to an end user?

Question

I'm looking for a GUI tool that requires minimal configuration which will enable an end-user (read cheap help) to add/delete/change MySQL table entries.

I don't want a tool that is a MySQL manager, configurator, administrator, etc. Just a simple front-end to display and manipulate data in a table.

What suggestions do you have?

I've looked all over and feel like I'm missing the obvious.

Answer 1

You can use phpMyAdmin and set the user permissions to the table just to select data. The interface itself will adapt.

I'm supposing you're looking for web based solutions. I have some old clients in a hosting company named "dreamhost" and they offer this solution in a sub domain and it works pretty well.

Are you looking into an amazing GUI interface, or phpMyAdmin wth proper privilegies works for you?

Answer 2

HeidiSql

Answer 3

Recently I came across SQLBuddy and fell in love with it ...

It feels a bit like phpMyAdmin but more elegant. The login is based on the mysql authentication, so the user needs to be set up properly in the database.

Answer 4

There's the MySQL GUI Tools/MySQL Workbench. They handle pretty much anything you can throw at them and are open source, free, and cross platform compatible. For end-users, you would only want to install the Query Browser from the GUI Tools.

I also mentioned Workbench because the GUI Tools are discontinued with all of their features being rolled into Workbench.