Problem connecting to mySQL on web host

dongna · Post by **dongna** » Wed 13 Oct 2010 15:46

I have a working Delphi application that connects to a remote mySQL database on my hosted web site. I say "working" because it was working (and had been working for years) as of last Friday.

Over the weekend my web hosting company did some updates on mySQL. Since then, I am unable to connect. Web hosting company says the problem is in my application.

I'm not sure what information would be helpful.

In my MyConnection, I have the following properties set:

Database
Password
Server
Username

I have verified that all these are correct by entering them on a "connection test" page provided by my web host.

What I do not understand is that when I run my application and attempt to connect through the MyConnection, I am getting the following error:

Access denied for user ''@'adsl-75-24-141-246.dsl.chcgil.sbcglobal.net' (using password: NO)

My local internet service is provided through sbcglobal DSL. It appears as if my router/modem is passing different login information to my web host?

In working with my hosting company, I have added the following as "remote database access hosts"

75.24.141.246
75.24.141.246.dsl.chcgil.sbcglobal.net

Have been struggling with this for 2 days and am not sure how to proceed... any help greatly appreciated.

dongna · Post by **dongna** » Thu 14 Oct 2010 15:48

Many views, no responses. Am I explaining my problem clearly? If not, I will be happy to try and clarify.

As a follow up, in discussing this problem with my web hosting company, they are insisting that the username and password that is being passed is not what I have specified in my MyConnection. This would appear to be confirmed by the text of the error message I'm getting.

The web hosting company is assuming I'm running a script and they're asking for a copy to help diagnose. I've explained that it's a compiled Windows executable.

Is there any way to troubleshoot exactly what my application is sending as login information?

AndreyZ · Post by **AndreyZ** » Fri 15 Oct 2010 08:34

Hello,

Try reseting your password on the server. If it doesn't help, then upgrade MyDAC to version 6.00.0.1 and try connecting to web host with it.

dongna · Post by **dongna** » Mon 18 Oct 2010 15:42

AndreyZ wrote:Try reseting your password on the server. If it doesn't help, then upgrade MyDAC to version 6.00.0.1 and try connecting to web host with it.

I upgraded MyDAC as suggested, and that fixed the problem.

Thank you!

AndreyZ · Post by **AndreyZ** » Tue 19 Oct 2010 06:16

It is good to see that this problem has been solved.