配置OGG到MySQL复制时登陆MySQL报错解决

1.MYSQL登陆报错[Oracle@bys2 mysqlogg]$ mysql -u root -pEnter password: ERROR 1045 (28000): Access denied for user

1.mysql登陆报错
[oracle@bys2 mysqlogg]$ mysql -u root -p
enter password:
error 1045 (28000): access denied for user 'root'@'localhost' (using password: yes)

此时使用 mysql -u root 即不使用密码可以登陆。

重改密码：使用root用户操作
# /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; ---刷新数据库中数据。
mysql> quit
# /etc/init.d/mysqld restart
此时就可以使用密码登陆了。
# mysql -u root -p
enter password:
mysql>

2.ogg中登陆mysql报错解决
ggsci (bys2.oel.com) 2> dblogin sourcedb oggtest,userid root
password:
2013-08-30 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/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.1_platforms_120423.0230
linux, x86, 32bit (optimized), mysql enterprise on apr 23 2012 04:29:30
copyright (c) 1995, 2012, oracle and/or its affiliates. all rights reserved.
ggsci (bys2.oel.com) 1> dblogin sourcedb oggtest,userid root
password:
successfully logged into database.

推荐阅读：

两台Oracle之间配置OGG-未配置同步DDL 

OGG配置DML单向复制一例及错误分析

Tana

“节点式”AI智能笔记工具，支持超级标签。

80

查看详情

OGG-00446 ERROR: Could not find archived log 

Oracle Linux 5.7 部署OGG v11 oracle to oracle 

GoldenGate源端意外宕机，导致OGG-01031报错