报错:com.github.shyiko.mysql.binlog.network.AuthenticationException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
解决方案:在mysql中执行以下命令
alter user 'root'@'localhost' identified with mysql_native_password by '密码'; 修改认证规则
刷新权限
flush privileges;
报错:The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone.
my.ini配置文件增加配置
[mysqld]
default-time-zone='+08:00'
查看区时 如下图:
show variables like'%time_zone'; 文章来源:https://www.toymoban.com/news/detail-681826.html
文章来源地址https://www.toymoban.com/news/detail-681826.html
到了这里,关于Java监听mysql的binlog 报错解决办法的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!