Same Host and Username with Multiple ACL Privileges mySQL

In mySql, as far as my understanding goes, its possible for us to grant privileges for same user name from different hosts. eg. user 'karthick' @ localhost could be assigned privileges different from user 'karthick' @ madhost.com

But, will it be possible to connect to a database with same user name and from same host but with different privileges? For eg. like fopen("file.txt","r") & fopen("file.txt","w"); will we be able to connect to database from the sa开发者_高级运维me host with the same username but different privileges?

To my knowledge, you can assign different privileges for the same user, but not on to the same database on the server. If you could, the server would not know which set of permissions to use. If it is on a different server, it will just be a new user which has the same username and password. They won't be linked in any other way.