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?
Why does schema compare need to select from mysql.user?
-
- Posts: 1
- Joined: Thu 09 Apr 2020 21:57
Re: Why does schema compare need to select from mysql.user?
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