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

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Idea

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

Post by Idea » 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

IDEA

Details

Post by IDEA » Mon 11 Jul 2005 06:41

It appened only if I create the exe on the Version 4.0 whith previous version i do not have this problem.

Regards
IDEA

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Mon 11 Jul 2005 08:40

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.

Post Reply