搜了下国内的一些博客和论坛,基本上都无法解决我的问题。
我的mysql版本是8,因为用记事本修改了my.ini文件,然后mysql80服务打不开。
在谷歌上搜到一个解决方案,神解决:用记事本将my.ini文件编码改成ANSI另存一下即可。
附上原文链接地址和评论:
review1:If using version 8 and you edit the my.ini I found that Notepad is putting 3 hex characters at the beginning of the my.ini file. EF BB BF. Deleting the 3 characters from the beginning of the file in a hex editor fixes the problem.
In version 8 they are accidentally putting Unicode characters in the ini file. This is causing Notepad to save the file with Byte order mark characters.
The following line in the file is the culprit "The line # range from 1 to 2^32 − 1. “Unique” means that each ID must be different." has 3 Unicode characters. This is causing notepad to append the byte order mark to the text file.
review2:You can also choose the ANSI encoding in the "save as..." dialog and ignore the following warning. Thanks for the tip!