workbench for mysql

Forum Moderators: open

Message Too Old, No Replies

workbench for mysql

is this what i need?

wingslevel

3:22 pm on Nov 6, 2009 (gmt 0)

we are switching the db for our ecommerce site from sql to mysql.

currently we can access the sql database from our desktops via a custom cms that was written in vb

can we use workbench for this in the mysql environment? example 1, a supplier changes the case pack on an item from 12 to 24 - we'd like one of our customer service reps (non-technical person) to be able to access that record and change the pack info - example 2, lets say we realize that blue widgets are wrongly categorized in the outdoor widgets category instead of in the indoor widget category - we'd like to be able to reassign this item to the correct category

is this what workbench does?

whoisgregg

2:46 pm on Nov 25, 2009 (gmt 0)

I'm not familiar with Workbench, but it appears from the MySQL page about it [mysql.com] that it's a piece of software for designing your database schema, not for manipulating data in your database.

You could use something like phpMyAdmin to manage the data in your database, but I wouldn't give access to a database-level admin tool to a "non-technical person." It'd be much better to have a custom admin (web-based or desktop) written that severely limits what changes a non-technical person can make to the data.