Devart Forums

MyDac: 3.55
Delphi 7 Ent
MySQL: 5.02

When i connect locally with a user that has only permission to a specified db i get no error;
when i try to connect with this user from another computer i get "access denied for thisuser@computer", but computer is not where the db is located;
when i connect with root (has all permissions on all mysql db) no problem;
Any help?

PS: I do not want to give the user permissions beyond a specific db;

If you granted permissions for thisuser@localhost and try to connect to the server from another host. For example from that_host. MySQL server denies access because permissions for the thisuser@that_host are not granted. Please see the corresponding topic of MySQL Reference Manual for details.

Yes, i did dig a bit more on mysql documentation and found the solution you point. Thanks.