Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Mysql Workbench error 1142 "Error querying security information" on Data Export

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?

like image 524
the_nuts Avatar asked Dec 30 '15 01:12

the_nuts


3 Answers

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/

like image 153
Wes H Avatar answered Nov 13 '22 11:11

Wes H


Update as of 13th June 2016

This bug has now been fixed

Download 6.3.7 (or later if available) from here

like image 26
StudioTime Avatar answered Nov 13 '22 12:11

StudioTime


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

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

like image 8
the_nuts Avatar answered Nov 13 '22 11:11

the_nuts