database restriction

Hi All, Can anybody tell me how to restrict someone from using a specified database? eg: user is not allowed to use database mysql for security reason. TIA Alex Lui - Before posting, please check: http://www.mysql.com

mysql.user to be used as application login password table

password table. Is it ok to use this table to control the access right of a PHP program instead of creating another one for that. Thanks for any suggestion. Alex Lui - Before posting, please check: http://www.mysql.com/manual.php

Reset the root Password in MySQL

Hi all, I have just installed MySQL recently. I already set the root password and some databases testing and everything worked fine. However, I accidentally changed the root to anonymous yesterday. After that, I couldn't add new users and do some administration tasks even change password myself.