Minimum Rights Required to Compare Schemas

Last modified: March 28, 2025

For successful and reliable schema comparison, you need to grant at least the Read privilege for the following objects.

A person, who performs comparison, should have the following privileges:

grant select on *.* to '<user_name>'@'%';
grant show view on *.* to 'user_name'@'%';
grant event, trigger on *.* to 'user_name'@'%';

Was this page helpful?

Yes

Want to find out more?

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

If you consider employing this tool for your business, request a demo to see it in action.