在 Win10 安装 MySQL Workbench 后连接 MySQL 服务器,点击 Server Status 状态面板会报错:Could not acquire management access for administration,网上搜了一下解决方法,顺便记录一下~
解决方法
原因:Windows中文桌面默认编码问题
路径:C:\Program Files\MySQL\MySQL Workbench 8.0 CE\workbench 下的 os_utils.py 文件约356行
默认是:
process = subprocess.Popen(command, stdin = subprocess.PIPE, encoding="utf-8", stdout = subprocess.PIPE, stderr = subprocess.STDOUT, shell=True)修改为如下:
process = subprocess.Popen(command, stdin = subprocess.PIPE, encoding="gbk", stdout = subprocess.PIPE, stderr = subprocess.STDOUT, shell=True)修改完成后,重新打开 MySQL Workbench 既可!

