Error 1042: (Hy000): Can't Get Hostname for Your Address in MySQL 5.5 (Doc ID 1311838.1)

Last updated on MARCH 08, 2017

Applies to:

MySQL Server - Version: 5.5 and later   [Release: 5.5 and later ]
Generic Windows

Symptoms

On : 5.5 version after upgrading from 5.1 or previous versions

When attempting to connect to the database service,the following error occurs.

ERROR
-----------------------
Error 1042: (HY000): Can't get hostname for your address

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup host/DNS details based on netbios names
2. Upgrade to 5.5 version

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot access the database service remotely since the hostname is not resolving. Customer is forced to use the IP address instead.

Changes

Upgrading to 5.5 version of MySQL Server

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms