Re: user can see more than it's allowed to see?

2006-06-21 Thread Bing Du
> > database test itself has Grants that it shows itself to everyone. > How should I verify that? Thanks, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: user can see more than it's allowed to see?

2006-06-21 Thread Barry
Bing Du schrieb: Hello, I don't understand why user 'test1user' can see database 'test' as well. I think user 'test1user' should only be able to see database 'test1'. What did I do wrong here? I'd appreciate any help. Thanks. As root: mysql> show databases; +---+ | Database

user can see more than it's allowed to see?

2006-06-21 Thread Bing Du
Hello, I don't understand why user 'test1user' can see database 'test' as well. I think user 'test1user' should only be able to see database 'test1'. What did I do wrong here? I'd appreciate any help. Thanks. As root: mysql> show databases; +---+ | Database | +--