Mysql Workbench错误1142“错误查询安全信息"；关于数据导出 [英] Mysql Workbench error 1142 "Error querying security information" on Data Export

问题描述

昨天我将工作台更新为可用的最新版本，即Windows 10上的6.3.6 build 511 CE.

yesterday I updated my Workbench to the latest version available, the 6.3.6 build 511 CE on Windows 10.

现在，我正在尝试通过一直有效的数据导出"功能对远程数据库进行转储.

Now I'm trying to make a dump of a remote database via the "Data Export" feature, which has always worked.

但是，一旦我单击开始导出"按钮，就会出现此错误:

But, as soon as I click the "Start Export" button, I get this error:

未处理的异常:查询安全信息时出错:错误 执行'SELECT * FROM mysql.user WHERE user =' [用户名] '并且 主机=' [主机] '按用户，主机订购" 表'user'的用户' [username] '@@' [host] '的SELECT命令被拒绝 SQL错误:1142

Unhandled exception: Error querying security information: Error executing 'SELECT * FROM mysql.user WHERE user = '[username]' and Host = '[host]' ORDER BY User, Host' SELECT command denied to user '[username]'@'[host]' for table 'user' SQL Error: 1142

我知道我没有读取该表的权限，但是为什么需要执行该操作才能导出数据?

I know that I don't have the permissions to read that table, but why is that needed to perform a data export?

我尝试检查force选项(Continue even if we get an sql-error)，但仍然无法正常工作.

I've tried to check the force option (Continue even if we get an sql-error) but it's still not working.

这是Workbench的错误吗?还是有什么办法可以避免这种查询?

Is this a Workbench bug? Or is there any way to avoid this query?

推荐答案

2016年6月13日更新

此错误现已修复

从此处

这篇关于Mysql Workbench错误1142“错误查询安全信息"；关于数据导出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！