I've been connecting to mySQL server on my webhosting package to insert data into crystal reports. Used it pretty regularly, but in the last couple of months haven't touched it.

Then today I wanted to fire off an up to date report but keep getting an access denied error. I went into the mySQL Connector/ODBC and checked it. The data hasn't changed however in the diagnostics of that tool I keep getting the following error when testing the connection:
Anyone know why its using the address "xxx-xxx-xxx.ntlworld.ie" instead of the webhosting address? (the x's are numbers)

Got it sorted... My IP address changed since I last used it so I had to add my new IP to the mySQL remote hosts access list!