An error occurred while logging on to MySQL during OGG to MySQL replication.

1. MYSQL login Error
[Oracle @ bys2 mysqlogg] $ mysql-u root-p
Enter password:
ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES)

In this case, use mysql-u root to log on without a password.

Password re-change: Use the root user
#/Etc/init. d/mysql stop
# Mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking &
# Mysql-u root mysql
Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root ';
Mysql> flush privileges; --- refresh the data in the database.
Mysql> quit
#/Etc/init. d/mysqld restart
Now you can use the password to log on.
# Mysql-u root-p
Enter password:
Mysql>

2. troubleshooting when logging on to MYSQL in OGG
GGSCI (bys2.oel.com) 2> dblogin sourcedb oggtest, userid root
Password:
12:03:14 WARNING OGG-00769 MySQL Login failed:. SQL error (2002). Can't connect to local MySQL server through socket '/tmp/mysql. sock' (2 ).
ERROR: Failed to connect to MySQL database engine for HOST localhost, DATABASE, USER root, PORT 3306.

GGSCI (bys2.oel.com) 3> exit
[Oracle @ bys2 mysqlogg] $ su-
Password:
[Root @ bys2 ~] # Ln-s/var/lib/mysql. sock/tmp/mysql. sock
[Root @ bys2 ~] # Exit
Logout
[Oracle @ bys2 mysqlogg] $./ggsci
Oracle GoldenGate Command Interpreter for MySQL
Version 11.2.1.0.1 oggcore_11.2.1.0.20.platforms_120423.0230
Linux, x86, 32bit (optimized), MySQL Enterprise on Apr 23 2012 04:29:30
Copyright (C) 1995,201 2, Oracle and/or its affiliates. All rights reserved.
GGSCI (bys2.oel.com) 1> dblogin sourcedb oggtest, userid root
Password:
Successfully logged into database.

Recommended reading:

Configure OGG between two Oracle servers-synchronization DDL is not configured

One case of OGG configuring DML unidirectional replication and Error Analysis

OGG-00446 ERROR: cocould not find archived log

Oracle Linux 5.7 deploy OGG v11 oracle to oracle

GoldenGate source unexpected downtime, resulting in OGG-01031 Error