Page 1 of 1

Problem on accessing to mysql from different Computer on the same net

Posted: Mon 11 Jul 2005 06:30
by Idea
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

Details

Posted: Mon 11 Jul 2005 06:41
by IDEA
It appened only if I create the exe on the Version 4.0 whith previous version i do not have this problem.

Regards
IDEA

Posted: Mon 11 Jul 2005 08:40
by Ikar
This message can be raised if the server doesn't take name of user/password/client name.
You must add another computers at the list of available at the server. Please see MySQL Reference for details.