MySQL 发生系统错误 1067
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4577356/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
system error 1067 has occurred
提问by Spencer B.
Ran into some troubles with XAMPP after MySQL wasn't starting. So, I typed in the command prompt: 'net start MySQL', and it gave me this error message listed in the subject line.
在 MySQL 没有启动后，XAMPP 遇到了一些麻烦。所以，我在命令提示符下输入：'net start MySQL'，它给了我在主题行中列出的这个错误消息。
Anyone know how to alleviate this? Thanks for your help!
有谁知道如何缓解这种情况？谢谢你的帮助！
回答by Giraldi
This did the trick for me:
这对我有用：
Of course, in this case, you have to completely clean up the xampp folder, which doesn't always happen. I guess I backed up the necessary files first (data folderfrom mysql folder and the htdocs folder). Uninstall XAMPP. Check the xampp folder for any content that remains and delete everything. You may want to reboot afterwards, just in case. Then reinstall XAMPP. Copy the backed-up folders back to their respective places, and hopefully, mySql will work again in XAMPP.
当然，在这种情况下，您必须完全清理 xampp 文件夹，这并不总是发生。我想我首先备份了必要的文件（来自 mysql 文件夹和htdocs 文件夹的数据文件夹）。卸载 XAMPP。检查 xampp 文件夹中是否有任何剩余内容并删除所有内容。您可能想在之后重新启动，以防万一。然后重新安装 XAMPP。将备份的文件夹复制回各自的位置，希望 mySql 能够在 XAMPP 中再次运行。
回答by boryn
In my case it was enough to give full (absolute) paths to the xampp/mysql/bin/my.inifile. For example I changed basedirfrom "/xampp/mysql/"to: "E:/xampp/mysql/", and so on.
就我而言，提供文件的完整（绝对）路径就足够了xampp/mysql/bin/my.ini。比如我改变basedir来自"/xampp/mysql/"于："E:/xampp/mysql/"，等等。
回答by eng hwie
I encountered exactly the same problem. Here is the solution that work for my situation. In my case I already installed xamp with mysql listening to port 3306, also I have mysql 5.0 listening to port 3307. Then I am trying to install 64 bit mysql version 5.6 listening to port 3308, I already define it in my.ini, and then start cmd (must be open by run as administrator). My installation was "d:\mysql64", then go to that folder in cmd dialog box, then type "bin\mysqld --install mysql64 --default-file=d:\mysql64\my.ini". It was said that service installed successfully but when I try to start it by "net start mysql64", it give that error 1067.I also already try to install and reinstall several times by modifying my.ini but the problem persist.
我遇到了完全相同的问题。这是适用于我的情况的解决方案。在我的例子中，我已经安装了 xamp，mysql 侦听端口 3306，还有 mysql 5.0 侦听端口 3307。然后我尝试安装 64 位 mysql 版本 5.6 侦听端口 3308，我已经在 my.ini 中定义了它，并且然后启动cmd（必须以管理员身份运行打开）。我的安装是“d:\mysql64”，然后在cmd对话框中进入那个文件夹，然后输入“bin\mysqld --install mysql64 --default-file=d:\mysql64\my.ini”。据说服务安装成功，但是当我尝试通过“net start mysql64”启动它时，它给出了错误1067。我也已经尝试通过修改my.ini多次安装和重新安装，但问题仍然存在。
The solution is =
解决办法是=
remove the service by "bin\mysqld --remove mysql64"
reinstall the service by "bin\mysqld --install mysql64 --port=3308" ----> this is the solution
try to start mysql64 by window services or by "net start mysql64"
通过“bin\mysqld --remove mysql64”删除服务
通过“bin\mysqld --install mysql64 --port=3308”重新安装服务---->这就是解决方案
尝试通过窗口服务或“net start mysql64”启动mysql64
It will started successfully.
它将成功启动。
So in this case seems that --default-file argument was ignored by window service manager, because I already define the port in my.ini but the service can not start and giving 1067 error
所以在这种情况下，窗口服务管理器似乎忽略了 --default-file 参数，因为我已经在 my.ini 中定义了端口但服务无法启动并给出 1067 错误
回答by Raul Luna
I had the same problem, but on windows. What I've found is that the service was created under an unpriviledged account (in my case nt_authority). When I changed this to the "system" account, everything worked.
我有同样的问题，但在 windows 上。我发现该服务是在非特权帐户（在我的情况下为 nt_authority）下创建的。当我将其更改为“系统”帐户时，一切正常。
回答by Sae1962
I think that at least a warning should be added to the product when the user tries to install MySQL on a path that contains whitespaces. This was the reason for the error "System error 1067 has occurred", which vanished after reinstalling MySQL under a path without blanks (used C:\Programs instead of C:\Program Files, which unfortunately appears in German Windows 10 as C:\Programme, i.e. w/o any spaces!).
我认为当用户尝试在包含空格的路径上安装 MySQL 时，至少应该向产品添加警告。这就是错误“发生系统错误 1067”的原因，在没有空格的路径下重新安装 MySQL 后该错误消失了（使用 C:\Programs 而不是 C:\程序，即没有任何空格！）。
回答by Famver Tags
Thisor thismight help you, if you're on windows
According to the posts, uninstalling then reinstalling with the --defaults-file option would fix the problem. Make sure to have the Services manager window closed, as this can cause weird bugs while trying to fix the problem
根据帖子，使用 --defaults-file 选项卸载然后重新安装可以解决问题。确保关闭服务管理器窗口，因为这可能会在尝试修复问题时导致奇怪的错误
回答by Trav
You can re-register your mysqld as a service and have it point to the my.cnf file with the proper data directory set: See http://www.jerrytravis.com/?p=533for directions on how to do so. The article in the link refers to doing it when you've moved a Zend Server folder, however, the procedure will work for any msyql installation. Just cd to the proper directories.
您可以将您的 mysqld 重新注册为服务，并使其指向具有正确数据目录集的 my.cnf 文件：有关如何操作的说明，请参见http://www.jerrytravis.com/?p=533。链接中的文章提到在您移动 Zend Server 文件夹时执行此操作，但是，该过程适用于任何 msyql 安装。只需 cd 到正确的目录。
