Otter:connect /192.168.10.225:3306 failure:java.io.IOException: Error When doing Client
来源:互联网 发布:淘宝网车用抱枕被 编辑:程序博客网 时间:2024/04/29 04:54
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 的用户权限查看:
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>
因为不同的版本问题,导致创建用户的赋予权限,密码出现了不同,设置成'%'的时候,会导致 'localhost'无法登录。需要用命令单独去用'localhost'在运行一次
- Otter:connect /192.168.10.225:3306 failure:java.io.IOException: Error When doing Client
- Hive Internal Error: com.sun.jersey.api.client.ClientHandlerException(java.io.IOException: java.net.
- Failed to connect sshd on "10.6.6.229:99"ProxyHTTP:java.io.IOException:proxy error:Service Unavailab
- POIFSFileSystem java.io.IOException: Read error
- java.io.IOException: No error in nativeavailable
- Failed to connect sshd on "10.6.x6.29:99"ProxyHTTP:java.io.IOException:proxy error:Service Unavailab
- hadoop报错java.io.IOException: Bad connect ack with firstBadLink as 192.168.1.218:50010
- java.io.IOException: Bad connect ack with firstBadLink as
- java.io.IOException: Got error, status message , ack with firstBadLink as 192.168.*.* 50010
- 连接mysql报Communication link failure: java.io.IOException, underlying cause: Unexpected end of input s
- java.io.IOException: Error initializing HTTP tunnel connection:
- java.io.IOException: error 10054 during TCP read问题
- Cannot run program : java.io.IOException: error=2
- java.io.IOException: [Management:141245]Schema validation error 的解决方法
- Error in dependencyCheck java.io.IOException: invalid manifest format
- eclipse CSV连接:ProxyHTTP:java.io.IOException:proxy error
- java.io.IOException: error=24, 打开的文件过多
- 严重: Error in dependencyCheck java.io.IOException: invalid header field
- mysql 对用户授权的操作
- ubuntu之apache正向代理及反向代理(ProxyPass/ProxyPassReverse)
- C++ Note-Template-01
- yii框架ajax上传
- android 4.4 appcompat gradle 构建jar包兼容性问题
- Otter:connect /192.168.10.225:3306 failure:java.io.IOException: Error When doing Client
- 初始化logback的变量
- 获取验证码显示的两种简单实现,交互绝非偶然~
- javaEE基础面试题
- 关于更高效率做事的一些思考
- Android自定义控件--仿安全卫士中的一键加速
- 3-6 静态数据成员与静态成员函数(c++)
- 字符串匹配
- 马斯洛的五大需求层次理论