Problem on accessing to mysql from different Computer on the same net
Posted: Mon 11 Jul 2005 06:30
We are testing Mydac on our lan for a migration to mysql.
We recognise a problem, is we compile a project on delphy 7 using Mydac, we set the connection using the static ip of our MySQL server : the exe creted on a computer does NOT WORK on the other PC on the lan, it works only on the pc where we copile it.
On the other pc on the lan it give me an error like :
Access denied for user 'idraulici'@'%' to database ' select * from artest order by gruppo'
I Have to recompile the EXE on every pc on the lan, it isn't possible!
it is normal or what?
Could You suggest any solutions?
Best Regards
IDEA
We recognise a problem, is we compile a project on delphy 7 using Mydac, we set the connection using the static ip of our MySQL server : the exe creted on a computer does NOT WORK on the other PC on the lan, it works only on the pc where we copile it.
On the other pc on the lan it give me an error like :
Access denied for user 'idraulici'@'%' to database ' select * from artest order by gruppo'
I Have to recompile the EXE on every pc on the lan, it isn't possible!
it is normal or what?
Could You suggest any solutions?
Best Regards
IDEA