MySQL Workbench 获得管理访问权限？

MySQL Workbench acquire access for administration?

提问by Andi1306

I run MySQL 5.6 since month and everything went well. Also the MySQL Workbench 6.

我从一个月开始运行 MySQL 5.6，一切顺利。还有 MySQL Workbench 6。

I receive two errors if I would like to see the "Server Status".

如果我想查看“服务器状态”，我会收到两个错误。

1st error:

第一个错误：

Could not acquire management access for admionistration
RuntimeError: Unable to execute comand chcp. Please make shure that
C:\Windows\System32 directory is in your PATH environment variable.

I checked the windows path variable within Win7 and there exist an entry c:\windows\system32

我检查了 Win7 中的 windows 路径变量，并且存在一个条目 c:\windows\system32

2nd error:

第二个错误：

Unable exception: Current profile has no WMI enable

Any ideas?

有任何想法吗？

回答by Iamat8

To resolve the issue, simply click on Manage Server Instancesunder Server Administrationcolumn and close the screen again. Now click on the instance again, check if the issue is fixed or report any bug.

要解决此问题，只需单击“服务器管理”列下的“管理服务器实例”并再次关闭屏幕。现在再次单击该实例，检查问题是否已修复或报告任何错误。

回答by SakthiSureshAnand

I thought your MYSQl Service is not yet start. Please Follow the below steps It works me like a charm.
windows + R - Type services.mscPress 'Enter' you could see many services . There is a service called MYSQl56 serviceif it's Disabledplease Start that Service then once again restart the workbench.

我以为您的 MYSQl 服务尚未启动。请按照以下步骤操作它就像一个魅力。
windows + R - 键入services.msc按“Enter”，您可以看到许多服务。有一个名为MYSQl56 服务的服务，如果它被禁用，请启动该服务，然后再次重新启动工作台。

回答by Vijay Nandwana

For those who are still facing issue, add "C:\Windows\System32" in "path" Environmental Variable and make sure "MySQL56" service is running.

对于那些仍然面临问题的人，请在“路径”环境变量中添加“C:\Windows\System32”并确保“MySQL56”服务正在运行。

回答by UdayKiran Pulipati

If you got below error when click on Manage Import / Exportoption

如果单击Manage Import / Export选项时出现以下错误

Previously asked question Backup of mysql DB not being createdis answered Exception: Current profile has no WMI enabled

先前提出的问题Backup of mysql DB not being created已回答异常：当前配置文件未启用 WMI

回答by UdayKiran Pulipati

I encountered this issue when trying to install my first mySQL server.

我在尝试安装我的第一个 mySQL 服务器时遇到了这个问题。

When configuring Remote Management, I overlooked the operating system setting for my server. I was using Windows but the default was set to FreeBSD. Once I changed the server OS setting to Windows, the problem went away.

在配置远程管理时，我忽略了服务器的操作系统设置。我使用的是 Windows，但默认设置为 FreeBSD。一旦我将服务器操作系统设置更改为 Windows，问题就消失了。

回答by Wee Zel

I just encountered exactly the same problem - read lots of suggestions but solutions didn't work for me (I can't un-install MySQL and re-install it on a live server)... ...my resolution, and what worked for me, was to copy chcp.com from C:\Windows\System32\ to C:\Windows\SysWOW64\ I guess it's a path problem between a 32bit version of MySQL/Workbench and the 64bit OS

我刚刚遇到了完全相同的问题 - 阅读了很多建议，但解决方案对我不起作用（我无法卸载 MySQL 并在实时服务器上重新安装它）... ...我的解决方案，以及什么对我有用，是将 chcp.com 从 C:\Windows\System32\ 复制到 C:\Windows\SysWOW64\ 我猜这是 32 位版本的 MySQL/Workbench 和 64 位操作系统之间的路径问题

回答by King14

I got the same problem after restarting my pc and solved it by just starting wampserver! so the solution is: 1. start wampserver- make sure apache,mysql are running and put all services online. 2.try to reconnect to the database!

重新启动我的电脑后我遇到了同样的问题，并通过启动 wampserver 解决了它！所以解决方案是： 1. 启动 wampserver- 确保 apache、mysql 正在运行并将所有服务置于在线状态。2.尝试重新连接数据库！

回答by woosah

Funnily enough, mine didn't work after the solution given by @mohit, and I'd rather not restart the computer as a work around as some has suggested.

有趣的是，在@mohit 提供的解决方案之后，我的没有工作，我宁愿不重新启动计算机作为一些建议的解决方法。

After doing some digging around, I found that the mysql server service was not running

经过一番挖掘，我发现mysql服务器服务没有运行

Task Manager --> Services --> [mysqlxx]right click and click start if not running. Note that. Note that [mysqlxx]could be a different format or name where xxare numbers

Task Manager --> Services --> [mysqlxx]如果没有运行，请右键单击并单击开始。注意。请注意，[mysqlxx]可能是一个不同的格式或名称，其中xx是数字