Re: Different Visible Databases for each User

[Jean Peter Paredes]

Its me again :3

i tried the commands below after creating a new user. i disabled *Grant* and *Create_User* options for him. the new user is 'shy' and 'localhost' is also his host. my user is 'mad' @localhost. before i created 'shy', there are about 20 different databases in our mysql instance. 'shy's only working with the databaseB database. so then i tried the codes below.

GRANT ALL on databaseB.* to 'shy'@'localhost' identified by 'shyspassword';
FLUSH PRIVILEGES;

i exit my sql yog. came back, log in shy, but he can still see the rest of the 20 databases.

where did i go wrong ?

thanks :)



Edited 1 time(s). Last edit at 02/22/2014 05:56AM by Jean Peter Paredes.