source导入sql文件出错ASCII '\0' appeared in the statement

作者：FancyPig | 发布时间：2021-10-29 17:08:48 | 更新时间：2021-12-30 17:52:10

错误代码

出现下面的错误代码

ERROR: 
ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: ''.
Bye

解决方案

登录mysql数据库用下面的命令

mysql --binary-mode=1 -u root -p

相当于比之前就增加了--binary-mode=1就解决了上述编码问题