mysql> show grants for nouveau@localhost; +--------------------------------------------------------------------------- ------------+ | Grants for nouveau@localhost | +--------------------------------------------------------------------------- ------------+ | GRANT USAGE ON *.* TO 'nouveau'@'localhost' IDENTIFIED BY PASSWORD '4be6641910d7bc1b' | +--------------------------------------------------------------------------- ------------+ 1 row in set (0.00 sec)
mysql> revoke usage on *.* from nouveau@localhost; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.01 sec) mysql> show grants for nouveau@localhost; +--------------------------------------------------------------------------- ------------+ | Grants for nouveau@localhost | +--------------------------------------------------------------------------- ------------+ | GRANT USAGE ON *.* TO 'nouveau'@'localhost' IDENTIFIED BY PASSWORD '4be6641910d7bc1b' | +--------------------------------------------------------------------------- ------------+ 1 row in set (0.00 sec) Is there a way to get rid of that? Is there a way to create a user by giving access to only one database, without giving him the permission to "mysqlshow --user=[thisuser] --password=[thispassword]" and retrieve all database names? He should see only the name of his database...? Thanks! - Christian Caron --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
