I was trying to migrate one of my MySQL databases, and when I backed up the original database with MySQL Workbench, I faced the following error when trying to restore it:

ERROR 1227 (42000) at line 26: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation

One of the pages on MS suggests that the problem might be related to DEFINERs. However, since I’m migrating a WordPress database, I did not have any DEFINERs, so this was not applicable to my situation.

Tips and Tricks in using mysqldump and mysql restore to Azure Database for MySQL | Microsoft Community Hub

At the end, I just found out that in my case, I had the following step in my SQL dump:

So, to resolve the issue, I opened the .SQL dump file with a text editor and completely removed the line “SET @@GLOBAL.GTID_PURGED=”. My problem was resolved, and I successfully restored the database!