访问配置时 MySQL Workbench 错误
安装 MySQL Community Server 5.59（64 位）和 MySQL Workbench 5.2.31a 并进行设置后，我尝试访问数据库的配置并收到以下错误：
找不到配置文件“C:\Program Files\MySQL\MySQL Server 5.0\my.ini”。应用更改后将创建新文件。
我单击“确定”。然后，当尝试应用任何更改时，我会收到第二个 IO 错误，因为无法写入文件。
看来我的安装位置是 C:\Program Files\MySQL\MySQL Server 5.5 而不是 C:\Program Files\MySQL\MySQL Server 5.0。但为什么 Workbench 在那里搜索呢？
After installing MySQL Community Server 5.59 (64bit) and MySQL Workbench 5.2.31a and setting it up I try accessing the db's configuration and receive the following error:
Configuration file 'C:\Program Files\MySQL\MySQL Server 5.0\my.ini' can not be found. New file will be created on apply of changes.
I click OK. Then when trying to apply any change I get a second IO Error for not being able to write to the file.
It figures as my installation is at C:\Program Files\MySQL\MySQL Server 5.5 and not at C:\Program Files\MySQL\MySQL Server 5.0. But why does Workbench search there?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
我在 MySQL Server 5.7 和 MySQL Workbench 6.3 上遇到了同样的问题。解决方案非常简单。
在我的情况下，我所要做的就是更改条目：
%ProgramFiles%\MySQL\MySQL Server 5.0\my.ini
到
%ProgramData%\MySQL\MySQL Server 5.7\my.ini
I had the same issue with MySQL Server 5.7 and MySQL Workbench 6.3. The solution is quite simple.
In my case all I had to do is to change the entry from:
%ProgramFiles%\MySQL\MySQL Server 5.0\my.ini
to
%ProgramData%\MySQL\MySQL Server 5.7\my.ini
中更改基本目录
尝试：您可以在
服务器管理-> 。管理器服务器实例>本地MySQL > 系统配置文件 >配置文件：\my.ini （点击目录）Try: You can change the base directory in
Server Administration-> Manager Server Instances > Local MySQL >system Profile > Configuration file : <your dir>\my.ini(Click the directory)您需要在 Workbench 的服务器管理部分创建一个新的服务器实例。您可以在此处指定 .ini 文件位置。
You need to create a New Server Instance in server administration section of Workbench. There you will be able to specify your .ini file location.
您的服务器实例注册错误。
当您在工作台中创建用于服务器管理的新服务器实例时，有一个选定的选项，例如：
如果您在当前的操作系统和服务器安装中选择了错误的安装程序，则会导致基本路径映射不正确。
要解决您的问题，您可以在服务器管理->更改基本目录。记录实例 ->配置菜单->配置->一般的：
1) 单击基本目录复选框
2）输入路径例如
3) 单击数据目录复选框
4）输入路径例如
Your Server instance is registered wrong.
When you create new server instance for server administration in workbench, there is a selected option, e.g.:
If you selected a wrong one with your current OS and Server installation, it would result an incorrect base path mapping.
To solve your issue, you can change the base directory in Server Administration-> Logging the instance -> Configuration Menu -> Configuration -> General:
1) Click the base directory checkbox
2) Input the path e.g.
3) Click the data directory checkbox
4) Input the path e.g.
乔纳森，当我看到我最初搜索的你的问题时，几分钟后我找到了答案。
正如您可能已经知道的那样连接它们，但迷失的灵魂可能会从中了解到，我们正在讨论的配置文件并不存在于 MySQL 内部。它位于
C:\Program Files (x86)\wamp\alias
当然，如果您正在使用它，请自己弄清楚您的
wamp所在的位置。就我而言，所需的文件位于alias文件夹中。我希望这对处理我的案件的人有所帮助。
致以最诚挚的问候和祝福。
Jonathan, when I looked upon your question for which I was originally searching I found the answer few minutes later.
To connect them as you already probably know but a lost soul may learn from this is that the configuration file we are talking about is not presented inside MySQL. It is located in
C:\Program Files (x86)\wamp\aliasOf course, figure it out for ourselves where your
wampis located if you are using it. In my case the desired file was inaliasfolder.I hope this would help someone with my case.
Best regards and blessings.