Login problem

jop · Post by **jop** » Tue 30 Jan 2007 15:06

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;

Antaeus · Post by **Antaeus** » Thu 01 Feb 2007 07:53

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.

jop · Post by **jop** » Thu 01 Feb 2007 10:50

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