Why does schema compare need to select from mysql.user?

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
john.brink
Posts: 1
Joined: Thu 09 Apr 2020 21:57

Why does schema compare need to select from mysql.user?

Post by john.brink » Thu 09 Apr 2020 22:00

Sometimes (but not always for some reason), when I try to run the schema compare tool I'll get the following error:

Error: Cannot describe an object. SELECT command denied to user 'developer'@'10.10.8.12' for table 'user'

When I run this in the GUI, I can skip past it. When I run it from a script, the process fails.

I have tried checking "Ignore permissions" in the comparison options.

Is there some way to make it stop looking at the user table? If not, why is this necessary?

alexa

Re: Why does schema compare need to select from mysql.user?

Post by alexa » Mon 13 Apr 2020 11:45

Please check if you have granted the Read privilege as described at https://docs.devart.com/schema-compare-for-mysql/advanced-topics/minimum-rights.html

Post Reply