Pid:1 nid:1 exception:canal:canal1:com.alibaba.otter.canal.parse.exception.CanalParseException: java.io.ioexception:connect/192.168.10.225:3306 Failure:java.io.IOException:Error When doing Client authentication: Errorpacket [errornumber=1045, Fieldcount=-1, message=access denied for user ' root ' @ ' 192.168.200.40 ' (using password: YES), sqlstate=28000, sqlstatemarker=#]
At Com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.negotiate (mysqlconnector.java:207)
At Com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.connect (mysqlconnector.java:71)
At Com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.connect (mysqlconnection.java:52)
At Com.alibaba.otter.canal.parse.inbound.mysql.MysqlEventParser.preDump (mysqleventparser.java:85)
At Com.alibaba.otter.canal.parse.inbound.abstracteventparser$3.run (abstracteventparser.java:158)
At Java.lang.Thread.run (thread.java:745)
caused by:java.io.ioexception:connect/192.168.10.225:3306 Failure:java.io.IOException:Error when doing Client Authentication:errorpacket [errornumber=1045, Fieldcount=-1, message=access denied for user ' root ' @ ' 192.168.200.40 ' ( Using Password:yes), sqlstate=28000, sqlstatemarker=#]
At Com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.negotiate (mysqlconnector.java:207)
At Com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.connect (mysqlconnector.java:71)
At Com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.connect (mysqlconnection.java:52)
At Com.alibaba.otter.canal.parse.inbound.mysql.MysqlEventParser.preDump (mysqleventparser.java:85)
At Com.alibaba.otter.canal.parse.inbound.abstracteventparser$3.run (abstracteventparser.java:158)
At Java.lang.Thread.run (thread.java:745)
At Com.alibaba.otter.canal.parse.driver.mysql.MysqlConnector.connect (mysqlconnector.java:74)
At Com.alibaba.otter.canal.parse.inbound.mysql.MysqlConnection.connect (mysqlconnection.java:52)
At Com.alibaba.otter.canal.parse.inbound.mysql.MysqlEventParser.preDump (mysqleventparser.java:85)
At Com.alibaba.otter.canal.parse.inbound.abstracteventparser$3.run (abstracteventparser.java:158)
At Java.lang.Thread.run (thread.java:745)
MySQL User Rights view:
Mysql> SELECT DISTINCT CONCAT (' User: ', user, ' @ ', ', host, '; ') as query from Mysql.user;
+---------------------------------------+
| Query |
+---------------------------------------+
| User: ' localhost ' @ '% '; |
| User: ' root ' @ '% '; |
| User: ' Root ' @ ' 127.0.0.1 '; |
| User: ' @ ' localhost '; |
| User: ' root ' @ ' localhost '; |
| User: ' @ ' Localhost.localdomain '; |
| User: ' Root ' @ ' localhost.localdomain '; |
| User: ' Root ' @ ' sdzn-otter '; |
+---------------------------------------+
8 rows in Set (0.00 sec)
Mysql>
Because of different version issues, resulting in the creation of user permissions, passwords appear different, set to '% ', will cause ' localhost ' unable to log in. You need to use the command to use the ' localhost ' in a single run once