i've read up and am able to add users with encrypted passwords. what i want to do is restrict a user to a database.
in the mysql db there is the users table and the db table. i understand that permissions in the users table override those of the db table. so what i do is this: 1) create a user in the users table with whatever permissions are appropriate (if there's a permission grant in the users table that refers to db restriction, i'm missing it)... 2) in the db table i create the user (same one i just put into the users table. now, when i log in locally as that user (the user can access from anywhere) i can still access other dbs. what am i not doing right? thanks, lloyd --------------------------------------------------------------------- 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
