Can someone tell me or...

[uemjg]

show where I can find information on the "permissions box" in the mysql section of ops. I would like to know what each individual column does by either revoking or granting permission.

thanks

[B&T]

Which one(s) don't you understand?

[uemjg]

on any of them. I hope to protect my dbase by revoking these permissions, but I would like to know what exactly they do. Is there a tutorial or explaination anywhere?

[B&T]

If you want to know the details . . . the go to mysql.com

Each of the entries is a mysql function which you are allowing or disallowing. You can read about each one of them there.

For example . . . do a search on Alter and you will see that giving that ability will allow someone to alter the properties of the table. Something you likely would not want to grant except for your admin purposes.

I have set up different users with different permissions. My admin user can do all (I use phpMyAdmin for table maintenance). My DB scripts user can do very little.

[uemjg]

I was able to revoke all the functions except "select". I wish there was a similar function that would disallow logging into the dbase...too bad there isn't because my website's admin. functions use the same username/password that is usd to login to the dbase.

For now I guess i'm safe until I can make safer restrictions within the website as I was trying before in the other thread.

Thanks for all the help!

[B&T]

select means read. if that is all you are going to do then it should work.

bad plan, having the user/passwords be the same.