Why does schema compare need to select from mysql.user?
Posted: 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?
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?