MySQL Workbench 中报错:Could not acquire management access for administration 解决办法(亲测有效)_默认编码

The image contains the following text:

MySQL Workbench

“Could not acquire management access for administration”

RuntimeError: Target host is configured as Windows, but seems to be a
different OS. Please review the connection settings.

Settings… 取消 (Cancel)

一、问题原因

问题的原因是由于中文桌面编码问题。在 MySQL Workbench 中,默认编码设置为 utf-8,但由于中文环境的原因,它可能无法正确处理中文字符。

二、解决办法

找到路径:C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench\os_utils.py

MySQL Workbench 中报错:Could not acquire management access for administration 解决办法(亲测有效)_#数据库_02

将 process = subprocess.Popen(command, stdin = subprocess.PIPE, encoding=“utf-8”, stdout = subprocess.PIPE, stderr = subprocess.STDOUT, shell=True)
中的编码修改为GBK

process = subprocess.Popen(command, stdin = subprocess.PIPE, encoding="GBK", stdout = subprocess.PIPE, stderr = subprocess.STDOUT, shell=True)

之后,重新启动Workbench,问题即可解决。

MySQL Workbench 中报错:Could not acquire management access for administration 解决办法(亲测有效)_中文字符_03