mysql connecting to local domain - access denied

[Miss Jacky]

Hi all,

I am moving accounts to a new server (from fedora to freebsd). Some clients use 'www.theirdomain.tld' as mysql host in their connection scripts. This worked fine, but on the new server, this gives an Access denied for user '<username>'@'<serverhostname>'.

Using '127.0.0.1' or 'localhost' to connect to works fine, but using a domain running on the same server, returning the main ip of the server, now gives this error.

Any ideas how to make this work like before?

 

[tweakservers]

does www.yourclientdomain.com resolve to the new server IP or old IP?

 

[Miss Jacky]

Hi,

The new one, triple checked

Is there some sort of (optional?) mysql log in which I can find more information about the exact reason for denying access?