Did you try: FLUSH PRIVILEGES;
Also, to see what user can do with his permissions you can try this: SHOW GRANTS FOR username; Mihail Quoting Yat-Shing Tam <[EMAIL PROTECTED]>: > Hi fellows, > > I have a MySQL privileges question and hope someone can provide some > input on it. > > I have setup a user who can access only one db, say 'DB1'. > About the privileges, I set the account privilege like this: > 1) In user table, this account has Host='%' User='user_name' > Password='pwd' and all other privileges are set to 'N'. > 2) In db table, this account has Host='%' Db='DB1' User='user_name' and > all other privileges are set to 'Y' EXCEPT grant_priv. > > Through MySQL Front GUI, the user login and is allowed to access 'DB1' > only and other dbs are not visible to this user. Very things look good at > this point, however, when I have a piece of java code try to access 'DB1' > with this user account through MM.MySQL JDBC I receive an access deny. > > Questions: > 1) Why it behaves like this? I thought if I can access through GUI > application with this account, I should have the same access through JDBC. > 2) Does this mean I have to use an account which has a global access > privilege(s) in order to access the db through JDBC?? > > Any input would be appreciated. > > Best regards, > Michael --------------------------------------------------------------------- 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
