(originally asked on StackOverflow but it was suggested that I ask here) - MySQL 5.1.41 community (Windows Server 2003) - .Net/Connector 220.127.116.11
I've just created a new user and rather than grant schema privileges I've granted rights on only specific tables. In other words, there are NO global or schema level permissions set, only permissions set are for a couple specific tables. This seemed like a perfectly acceptable policy and from what I've ready MySQL will search:
for appropriate permissions. However when I try to open a connection to the server using this new user account I receive a permission denied error.
Access denied for user 'xxxxxx'@'%' to database 'xxxxxxx'
I have tried with several different clients and the result is the same. I have also checked the server log and there are no additional details, just this:
110816 10:23:15 543 Connect firstname.lastname@example.org on xxxxxxxx 543 Init DB Access denied for user 'xxxxx'@'%' to database 'xxxxxxx'"
If I grant SELECT on the schema in question I can connect just fine. Am I misunderstanding the way the permission system works or should it work like I think?