The data store "HPI DataStore" [id=105030] was saved but cannot be published: An error occurred while trying to modify the data source schema: Error accessing tables metadata (APNX-1-4178-000)

We encountered this error last Fall in our dev environment, but were able to work around it until today. We thought it had something to do with our MySQL 5.8 upgrade (internal RDS) and the change to utf8mb4 defaults. Yet it was something different from that, and the timing was coincidental.

The stdout log didn't show an error when I clicked 'verify'. However, I accidentally discovered that clicking "Download DDL Script", generates the actual permissions error in our stdout log file.  In our case, it was related to a sandbox / experimental view that was created with improper SQL SECURITY definitions on an unrelated data store. After we fixed that error with that view in the database, our data stores verify ok.

We encountered this error last Fall in our dev environment, but were able to work around it until today. We thought it had something to do with our MySQL 5.8 upgrade (internal RDS) and the change to utf8mb4 defaults. Yet it was something different from that, and the timing was coincidental.

The stdout log didn't show an error when I clicked 'verify'. However, I accidentally discovered that clicking "Download DDL Script", generates the actual permissions error in our stdout log file.  In our case, it was related to a sandbox / experimental view that was created with improper SQL SECURITY definitions on an unrelated data store. After we fixed that error with that view in the database, our data stores verify ok.