是文件“my.ini"吗?在错误的地方? [英] Is the file "my.ini" in the wrong place?

问题描述

在 WorkBench 中，当我单击选项文件时，它说找不到C:\Program Files\MySQL\MySQL Server 5.0\my.ini"

In the WorkBench when I click on the Options File it says it can't find "C:\Program Files\MySQL\MySQL Server 5.0\my.ini"

我的机器上什至没有 5.0 版本，我只安装了 5.6 和 5.7 版本的服务器.

I don't even have version 5.0 on the machine, I've only installed versions 5.6 and 5.7 of the server.

但是在C:\ProgramData\MySQL\MySQL Server 5.5\my.ini"中有一个 my.ini.

However there is a my.ini in "C:\ProgramData\MySQL\MySQL Server 5.5\my.ini".

如果我只是复制文件，我假设有两个 my.ini 文件会对服务器造成混淆.或者他们会吗?为什么 WorkBench 会在错误的位置查找此文件?

If I just copy over the file I'm assuming that having two my.ini files will be confusing for the server. Or will they? And why is the WorkBench looking in the wrong place for this file?

这可能是除 root 之外的所有登录突然开始失败的原因吗?

Could this be why all login's except root have suddenly started to fail?

推荐答案

查看连接设置.右键单击连接并选择编辑连接"，以便您最终进入管理连接".

Have a look at the Connection settings. Right click on the connection adn select Edit Connections so you end up in Manage connections.

有一个名为 System Profile 的选项卡.确保此处配置文件的路径是正确的 ini 文件.在你的情况下，路径应该是 C:\ProgramData\MySQL\MySQL Server 5.5\my.ini

There is a tab called System Profile. Make sure that the path for Configuration file here is to the correct ini file. In your case the path should most likley be C:\ProgramData\MySQL\MySQL Server 5.5\my.ini

这篇关于是文件“my.ini"吗?在错误的地方?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！