Forum Moderators: open

Message Too Old, No Replies

MySQL user interface software

recommendations?

         

heisters

6:27 pm on Mar 16, 2006 (gmt 0)

10+ Year Member



Hi all,

I'm wondering if any of y'all might be able to recommend a piece of software that would easily allow users to edit MySQL tables, eg. add records, delete records, edit records. That's about all I want them to be able to do, so something like PHPMyAdmin is out. I'd also like it to be easily extensible so something in PHP and Open Source would be nice. Also, my users would really appreciate the slickness that is associated with AJAX.

Thanks much

cejun

7:31 pm on Mar 17, 2006 (gmt 0)

10+ Year Member



Personally I use SQLyog. It is free and does more then I will ever need it to do.

cejun

7:33 pm on Mar 17, 2006 (gmt 0)

10+ Year Member



Ooops! I didn't read your entire post. SQLyog is not web based, it is a desktop app kind of like myCCadmin only better.

bcolflesh

7:36 pm on Mar 17, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



...easily allow users to edit MySQL tables, eg. add records, delete records, edit records. That's about all I want them to be able to do, so something like PHPMyAdmin is out.

Why is it out? If you create users with add, delete, and edit permissions only for the tables you specify, that's all they'll be able to do via PHPMyAdmin.

heisters

7:51 pm on Mar 17, 2006 (gmt 0)

10+ Year Member



Why is it out? If you create users with add, delete, and edit permissions only for the tables you specify, that's all they'll be able to do via PHPMyAdmin.

Oh, I didn't know you could do that, my experience with PMA has been pretty limited. However, I'm still uninterested because I'd like a much more point-n-click, user-friendly GUI. PMA's GUI works fine for what it does, but I'm looking for something a non-technical user could grasp easily. PMA would possible work if it had a templating system so that I could use it as a back end, but create my own GUI. I should have stated that from the start, sorry.

bcolflesh

7:58 pm on Mar 17, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Maybe this would fit your requirements - Free, but not Open Source though:

[turboajax.com...]

henry0

8:08 pm on Mar 17, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



You could script a simple text area form system (with auth and security) tied to your DB
Seems like you are looking for a sub-CMS

heisters

8:13 pm on Mar 17, 2006 (gmt 0)

10+ Year Member



You could script a simple text area form system (with auth and security) tied to your DB
Seems like you are looking for a sub-CMS

Well, I've already started that. It's a little more complicated than text areas and auth; it has some AJAX niceties and tempating system so that I can roll out pages linked to new tables quickly and easily. The problem is I'd prefer to be contributing to, or working on top of code that already exists for maintainability purposes. I don't want to go and create a monolithic custom framework that my successor is going to be stuck maintaining or scrapping altogether.