MySQL priviledge/user restrictions...Admin

[Guest_imported]

This is the situation. We have a couple of people (using Windows) who create tables for our MySQL database (running on Linux). The problem is they don't have priviledges to edit or delete existing tables. This forces them to have to rename the table (i.e. tableX has to become tableX1, etc.) each time something needs to be changed. So there are a set of a dozen or so tables for each actual table needed.

Obviously it would be better if they had the ability to edit tables and save them. I need to know how to give them this ability. I've looked in the manual but all it has done is confuse me. It either seems to talk about stuff I think is the answer but it ends up not being it or I end up not being able to find any specific command(s) to try out what it's describing.

I'm assuming there is something (file/program) that comes with MySQL that I can edit/run to get the job done but I just can't figure out what.

Any insight would be most appreciated.

 

[sleipnir214]

MySQL does come with apps to manage it. They just don't have GUI frontends.

Since it looks like you're running Win32 on your workstations, I strongly recommend you take a look at MySQL-Front (

http://www.anse.de/mysqlfront/).

It's a very nice GUI tool for managing MySQL from Win32.


The best place to start for understanding MySQL permissions is the syntax for the GRANT statement (which gives permissions). Look at

http://www.mysql.com/doc/G/R/GRANT.html

______________________________________________________________________
Never forget that we are
made of the stuff of stars