Comming back to our problem, it seems to me that in mysql as soon as you create a user, even without any privileges he gets the right to see all the databases. Whenever I only create a user and
#######################
show grants for user@whatever;
#######################
gives me...
Hi Dave,
name of the MySQL data dictionary table that confirms which databases a user can currently "USE"?
The answer according to my knowledge is db in database mysql.
cheer
amir
Hi Dave,
I am confronted with the same problem. I am adminitrating mysql and I dont want to give certain users to see the other databases ( use <db> ) but upto now I am not successful to do that. I am working on it.
cheers
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.