I am trying to connect to my mysql database server (version 5.6) on the web, from Delphi 7 application...
With Mysql Workbench, it works OK, i can run select queries with my test user (the same user that not working in Delphi 7)...
In Delphi, where using TZEosConn 7.1.4-stable , typed correct hostname for DB server, correct username and password... (parameter loginprompt = false)
When I change "connected" to true, everything working OK...
But when i am trying to execute a simple query:
zq.SQL.Text:='SELECT field FROM database.TABLE where id='+inttostr(x)+';';
where zq is TZQuery, and x is integer,
I got this error: **EZSQLException .. SELECT Command denied for @my_internet_hostname **
When i am logged in MySQL Workbench, i see the same user with wildcard session, like mydbuser@% , the same select works fine
So i think, the problem is in ZEOS component, it adding automatically my internet provider hostname...
On the mysql server i have wildcard hostnames allowed ( simply - '%' - so all hosts can access my MYSql DB )
Can someone suggest me, what is the problem with my ZEOS component???
PS: Sorry for my english and formatting