1

I'm looking for a simple database admin tool that will allow non-technical users to perform data-entry into a database (imagine a striped down version of phpMyAdmin). It would preferably allow the developer to set restrictions on which tables and fields can be modified.

Edit: Most of the tools posted, so far, are developer oriented. I'm looking for something that provides bare-bone functionality but is highly refined (clean interface, organized layout, etc.).

Edit2: Found this linked in the phpmyadmin alternatives thread.

http://www.sqlbuddy.com

John Himmelman
  • 21,504
  • 22
  • 65
  • 80

4 Answers4

2

HeidiSQL

http://www.heidisql.com/

Kevin
  • 13,153
  • 11
  • 60
  • 87
  • Thx, I've never heard of this tool before. Its useful & free, so I'll give it a try but its too complex for the non-techie. – John Himmelman May 06 '10 at 15:43
1

Check out Webbased MySQL interface better that phpMyAdmin for a list of clients that might suit you.

In particular, I've worked with SQLYog before and found it to be a decent tool. Unfortunately, you're going to hit a limit with how "easy" these things are for non-technical users. Short of building an interface yourself, much of what you'll find out there is geared toward developers.

Community
  • 1
  • 1
ABach
  • 3,743
  • 5
  • 25
  • 33
0

Try Navicat

Navicat

We use this at work even tho we know how to code it manually.

I can give you a form for all of the data columns or you can view a whole table at once.

You can build queries using query the builder too.

Jonathan Czitkovics
  • 1,642
  • 11
  • 11
0

In 15 minutes you can have a CakePHP site scaffolded, baked, and customized for a very clean, simple, web interface. It's not the right tool for every job, but when you need customizability, you might just need to roll your own solution.

erjiang
  • 44,417
  • 10
  • 64
  • 100