im sure the problem is on mysql installation, but...

Willo · Post by **Willo** » Mon 05 Oct 2009 13:53

Hi;

hope someone can help me with this:

i have a Delphi 7 application that uses MyDAC 3.55.0.23, and it is working perfectly on a lan with a dedicated server and on a laptop with a standalone MySQL installation (localhost). On both cases TmyConnection.Options.Direct is set to True.

I need to install the application on another laptop, so i installed MySQL (same version), another GUI cliente for MySQL called Navicat and my app.

The MySQL is running, Navicat connects without a problem but my app returns an error: Access denied for user ''@'localhost' (using password: NO)

I create another small app that allows me to change server,user, password and to set Tmyconnection.Options.Direct to false or true, when change it to false i can connect without a problem; in fact a special version of my app with Direct set to False works fine.

So, i belive there is something different between both laptops with MySQL, but i dont know what!, i cant change Direct to False, the original app is already running on 120 computers.

any help will be greatly appreciated!

Dimon · Post by **Dimon** » Tue 06 Oct 2009 06:43

Please, try to download the latest MyDAC build (5.90.0.51) and check if this problem still exists.

Willo · Post by **Willo** » Mon 12 Oct 2009 20:16

i didn't do it yet, but lets say it solves my problem, i can't afford to upgrade now, and:

im still wondering why Tmyconnection can connect on one pc and can't on another. Same MySQL version, same model,memory, hard drive of laptop, (different OS version tough, the one where is working is using Windows Vista and the other is using XP SP 2)

anyway, thanks for the help...