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 | +---------------+ | LTM | | dummy | | mysql | | test | | test1 | +---------------+ 8 rows in set (0.00 sec) mysql> grant all on test1.* to [EMAIL PROTECTED] identified by 'test1user'; Query OK, 0 rows affected (0.06 sec) mysql> show grants for [EMAIL PROTECTED]; +----------------------------------------------------------------------------------------------------------------------+ | Grants for [EMAIL PROTECTED] | +----------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'test1user'@'localhost' IDENTIFIED BY PASSWORD '3b8031664a43a963' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `test1`.* TO 'test1user'@'localhost' | +----------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) As user test1user: mysql> show databases; +----------+ | Database | +----------+ | test | | test1 | +----------+ 2 rows in set (0.00 sec) Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]