Getting "Access denied for user" after MySQL 5.0 to 5.1 upg
Posted: Wed 21 Oct 2009 17:33
My web service provider just upgraded their MySQL installation from 5.0 to 5.1. We have long ago developed a Windows app that uses MyDAC for C++ Builder 5 components V3.50.0.17 that worked correctly until this new update.
Now, whenever attempting to remotely connect using my application I get the following message:
Access denied for user '@'74.126.72.250' (using password: NO)
This implies that the user name and password were not supplied to the server, but my application (and a small test app I wrote to test it) does in fact set these values in TMyConnection prior to opening it.
My web service provider doesn't know why this is happening and suggests it is something in the MyDAC components. I agree since I can connect to the database from our website scripts, and from the Query Browser remotely.
Any help is greatly appreciated since my application is now broken.
Thanks,
Muskie
Now, whenever attempting to remotely connect using my application I get the following message:
Access denied for user '@'74.126.72.250' (using password: NO)
This implies that the user name and password were not supplied to the server, but my application (and a small test app I wrote to test it) does in fact set these values in TMyConnection prior to opening it.
My web service provider doesn't know why this is happening and suggests it is something in the MyDAC components. I agree since I can connect to the database from our website scripts, and from the Query Browser remotely.
Any help is greatly appreciated since my application is now broken.
Thanks,
Muskie