Mysql Workbench error 1142 “Error querying securit

问题:

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:

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?

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

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

回答1:

Update as of 13th June 2016

This bug has now been fixed

Download 6.3.7 (or later if available) from here

回答2:

I had this exact same issue. The solution provided in this thread (same as the_nuts answer) is to uninstall 6.3.6 and install 6.3.4 from the archived versions: https://downloads.mysql.com/archives/workbench/

回答3:

Found, this is indeed a bug of the version 6.3.6:

MySQL Bugs: #79807: Workbench Data Export: Unhandled exception: Error querying security information

回答4:

MySQL Workbench has the correct behavior. If you are using a user other than 'root' MySQL Workbench will display that alert. However, if you setup your access to the server and database as root you will not run into problems exporting/importing because you have the right access to do so.