Page 1 of 1

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

Posted: Thu 09 Apr 2020 22:00
by john.brink
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?

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

Posted: Mon 13 Apr 2020 11:45
by alexa
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