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

Source: Internet
Author: User
Tags sql error mysql login

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:

2. troubleshooting when logging on to MYSQL in OGG
GGSCI ( 2> dblogin sourcedb oggtest, userid root
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 ( 3> exit
[Oracle @ bys2 mysqlogg] $ su-
[Root @ bys2 ~] # Ln-s/var/lib/mysql. sock/tmp/mysql. sock
[Root @ bys2 ~] # Exit
[Oracle @ bys2 mysqlogg] $./ggsci
Oracle GoldenGate Command Interpreter for MySQL
Version oggcore_11.
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 ( 1> dblogin sourcedb oggtest, userid root
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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.