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
