In order create users to access certain databases, you have to add the appropriate entries to the "user" and "db" tables in the mysql database--that is, the db that holds the general access information. There are numerous ways to get to them, and I'm not familiar with Windows MySQL operation, so perhaps someone else can help you with the specifics in your case.
it goes a little like this:
-create a user in the "user" table, but do not assign any privileges to them. if you do, you could possibly be allowing access to the mysql configuration db tables. use the password() function if you want an encrypted password.
-create an entry in the "db" table for that specific user, indicating the database they are allowed to use and their exact privileges.
Those are the basics; the schema and view modes of operation aren't relevant to MySQL operation, as far as I know.
good luck.
knelson
