OGG MySQL Extract Abends With "OGG-00769 MySQL Login failed: . SQL error (2049). Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)" (Doc ID 2112277.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Oracle GoldenGate Capture for MySQL
  Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401
 Linux, x64, 64bit (optimized), MySQL Enterprise on Dec 11 2015 17:40:15

Extract and DBLOGIN fails with following error

2016-02-29 16:29:54 WARNING OGG-00769 MySQL Login failed: . SQL error (2049). Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled).

2016-02-29 16:29:54 ERROR OGG-00770 Failed to connect to MySQL database engine for HOST localhost, DATABASE , USER root, PORT 3305.

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