Re: ODBC Connection Failed when using Telstra

[Bogdan Degtyariov]

Hi Kevin,

The user name in MySQL consists of two parts 'mysql_user'@'client_host'.
The client_host part depends on how the client host network address is resolved.
It looks that the ODBC clients machines do not have neither a permanent global IP address nor a dedicated domain name. Hence, they are completely dependent on the name resolution.

I see two ways of dealing with the situation:

1. Less secure and hence less preferable would be creating a MySQL user
'MyUserID'@'%.lnk.telstra.net' or even 'MyUserID'@'%.telstra.net' on
the server side.

2. More proper and secure way is a global permanent IP address and a dedicated
domain name, which unambiguously identifies the user attempting the
connection.