It all began when i ported a project from Delphi 7 to Delphi 2007.
I try to do a select to a remote database and i get :
select command denied to user: 'firstname.lastname@example.org' for table 'myusers'
I have the old compiled executable that works fine !
If i open the original folder and recompile it with Delphi 7. The same problem arises.
I downloaded HeidiSQL. (A free MySQL front-end) http://www.heidisql.com/
and i got : select command denied to user: 'email@example.com' for table 'myusers' again !
And for all the other tables.
I closed and reopened HeidiSQL and in the left pane i could see my tables.
in the tabs above i could see a data tab. I clicked it and it showed all my data in the current table. I looked in the bottom panel and copy-paste the select command to the Query tab.
>> Check my uploaded picture <<
The selected SELECT worked !
I tried another SELECT. From that point on everything works fine.
HeidiSQL is working.
I don't know what i should do to make it work for my application !
(That has been working for 3 years now) ...
This is a crazy error. I have all the permissions for this user. I created it. I own the server.