My Oracle Support Banner

MySQL Login Failed While Using UserIDAlias (Doc ID 2862490.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms

GGSCI (server) 1> info credentialstore
Reading from credential store:

Default domain: OracleGoldenGate

Alias: db1
Userid: <username>@hostname:<port>/<db name>

GGSCI (server) 2> dblogin sourcedb <db name> useridalias db1

2022-03-02 16:23:03 WARNING OGG-00769 MySQL Login failed: . SQL error (2002). Can't connect to local MySQL server through socket '3333' (2).
Error: Failed to connect to MySQL database engine for HOST localhost, DATABASE <db name>, USER <username>, PORT



Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.