mysql workbench6.3 导入数据 Unhandled exception: Error querying security information SQL Error: 1142

mysql 新建用户并赋予指定数据库所有权限后，在在mysql workbench6.3 版本下无法导入数据，搜索stackoverflow发现这是mysql workbench6.3版本一个bug，升级版本后解决问题。

报错：

Unhandled exception: Error querying security information: Error executing 'SELECT * FROM mysql.user WHERE User='scg_api' AND Host='127.0.0.1' ORDER BY User, Host'
SELECT command denied to user 'scg_api'@'localhost' for table 'user'.
SQL Error: 1142

https://stackoverflow.com/questions/34521822/mysql-workbench-error-1142-error-querying-security-information-on-data-export

 

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