MySQL mysqlbinlog查看binlog时报错unknown variable 'default-character-set=utf8'解决
来源:互联网 发布:mac摄氏度符号怎么打 编辑:程序博客网 时间:2024/06/05 03:45
1.问题描述
C:\Users\heqianqian>mysqlbinlog mysql-bin.000003mysqlbinlog: unknown variable 'default-character-set=utf8'
2.原因
mysqlbinlog这个工具无法识别binlog中的配置中的default-character-set=utf8这个指令
3.解决方法
1.修改配置文件 —永久生效
windows环境下的my.ini
linux环境下的/etc/my.cnf
[client]#设置MySQL客户端的字符集default-character-set=utf8
把client下的default-character-set=utf8
修改成character-set-server = utf8
然后重启生效
2.无需重启环境
使用--no-defaults
mysqlbinlog --no-defaults mysql-bin.000003
阅读全文
0 0
- MySQL mysqlbinlog查看binlog时报错unknown variable 'default-character-set=utf8'解决
- MySQL mysqlbinlog查看binlog时报错unknown variable 'default-character-set=utf8'解决
- mysqlbinlog 查看binlog时报错unknown variable 'default-character-set=utf8'
- mysqlbinlog 查看binlog时报错unknown variable 'default-character-set=utf8'
- mysqlbinlog 查看binlog时报错unknown variable 'default-character-set=utf8'
- mysqlbinlog 查看binlog时报错unknown variable 'default-character-set=utf8'
- MySQL Binlog (异常) unknown variable 'default-character-set=utf8'
- mysqlbinlog: unknown variable 'default-character-set=utf8'
- mysqlbinlog: unknown variable 'default-character-set=utf8'
- mysqlbinlog: unknown variable 'default-character-set=utf8'
- mysqlbinlog: unknown variable 'default-character-set=utf8'
- mysqlbinlog: unknown variable 'default-character-set=utf8'
- linux下执行mysql时报错:unknown variable 'default-character-set=utf8'
- 解决mysqlbinlog: unknown variable 'default-character-set=utf8mb4'问题
- mysql mysqlbinlog: unknown variable 'default-character-set=gbk'解决方法
- mysqlbinlog异常之mysqlbinlog: unknown variable 'default-character-set=utf8'
- mysqlbinlog: unknown variable 'default-character-set=gbk'错误
- mysql启动报错 unknown variable 'default-character-set=utf8'
- JQuery库
- NDK在自己的SO中调用第三方SO
- Linux(Centos)之安装tomcat并且部署Java Web项目
- 获取不同元素与相同元素
- >>和>>>的区别
- MySQL mysqlbinlog查看binlog时报错unknown variable 'default-character-set=utf8'解决
- NIO编程 TimeServer && TimeClient
- 几种滤波器原理简析
- 更新网络状态码status code
- Ubuntu12.04下PyTorch详细安装记录
- Myeclipse导出jar包配置Main-Class
- 分享iMX6Q自编QT程序运行报缺少库文件问题解决方法
- jpa级联操作详解2--级联删除(CascadeType.REMOVE)
- Flume的配置