Not Able to Login to Server After Upgrade to 5.6 with Error 2049: "Authentication Protocol Refused" (Doc ID 1936052.1)

Last updated on MAY 08, 2017

Applies to:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

Symptoms

After upgrading to MySQL 5.6.20 in server, when tried to connect using " mysql -u root -p " the following error is shown:

ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

Changes

MySQL version >= 5.6.5

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