Control Center/New user creation.

[Gatorajc]

Not sure if this is where I asked this but here it goes.

Currently I am using Control Center 0.8.7 and it works good. The problem I am encountering is that if I create a new user they are able to see all the databases,tables, and the data inside, using contol center on their desktop. I do not want them to have this. I want them to only be able to see what I grant them permissions to. Am I doing something wrong or is just the way command center is. Kind of new to MySQL and being an admin. AJ
I would lose my head if it wasn't attached.

 

[danielhozac]

This is the query I use to create new users, it only allows them to use their own database:
[tt]CREATE DATABASE <username>;
GRANT ALL ON <username>.* TO <username> IDENTIFIED BY '<password>';[/tt] //Daniel

 

[QatQat]

The correct syntax is as follows


grant RIGHTS
on database.tables
to user@host
identified by &quot;password&quot;
;


where your rights can be

ALL
ALTER
CREATE
DELETE
DROP
FILE
INDEX
INSERT
PROCESS
REFERENCES
RELOAD
SELECT
SHUTDOWN
UPDATE
USAGE



Bye


Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)