Hello people, sorry for this very basic question but I got very confused
with access privileges to mysql. Until now I was using root to setup all the
tables and there was only access to this computer for myself only, but I
have a friend of mine who I want to give access to mysql database but I
don't want him to screw up my work or erase something of mine by accident so
I want to create database indfilm and user Tom that will have access only to
database indfilm and he will be able to create tables, delete them and
everything but will not be able to create new database or access other
databases or edit them... How do I do that? I added user Tom to user table
in mysql.
I am confused. Ok, what privileges should I have set for normal user and
what privileges should I have setup for administrator?
This is confusing, I was able to finally make user Tom to not be able to
create any tables but then he was able to access other databases on the
system instead only indfilm, so how do I set it up so user Tom can only
access indfilm database and be able to do everything he wants with that
particular database but he will not be able to see other databases or do
anything to them?
Thank you so much for your help.
Yes, I did read the manual, I went to devshed as well and they have great
explanation but somehow it still make this confusing for me.
Thank you for your help.
Chris
