Resolve the access denied error in a FreeSQLdatabase during schema comparison
When you compare a MySQL database as a source and a FreeSQLdatabase provided by freesqldatabase.com as a target using the default comparison options, you may encounter the following access denied error:
An error has occurred in <file_name>.scomp. Additional information: Unable to retrieve information about Users. SELECT command denied to user '<user_name>' for table 'user'. Do you want to continue process?
This error occurs because FreeSQL restricts access to system tables, and dbForge Schema Compare requires access to them to retrieve metadata during schema comparison.
Solution
To resolve this issue, on the Options page of the New Schema Comparison wizard, select Ignore permissions.
Example: Reproduce and resolve the error
Reproduce the error
2. Click Compare.
The access denied error appears, indicating that you have insufficient permissions, and schema comparison cannot be performed.
3. In the error window, click No.
Resolve the issue
1. In the New Schema Comparison wizard, navigate to the Options page.
2. Select Ignore permissions.
This option ignores security permissions during schema comparison and synchronization.
3. Click Compare.
The schema comparison document opens and displays the objects selected for synchronization.
