MySQL Forums
Forum List  »  Connector/ODBC

Re: ODBC Connection Failed when using Telstra
Posted by: Bogdan Degtyariov
Date: December 18, 2016 11:27PM

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'@'' or even 'MyUserID'@'' 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

Options: ReplyQuote

Written By
Re: ODBC Connection Failed when using Telstra
December 18, 2016 11:27PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.