Cannot export mysql data on workbench from azure (PROCESS privilege(s) ERROR)

i am currently on workbench 8.0.22 and I have a database on azure, to which I am connected. Since a week, when I try to export my data locally, using the UI of workbench, I receive this error:

mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

I have tried the following, to solve this:

disable add-locks and lock-tables in the export setting
create dump in single transaction
export data from the azure website directly (there is no export option displayed for me in the overview of the DB)

Thank you in advance for any help!

Solution

I suspect that you're connected to the database with a user account that does not have access to export the data. If a database administrator is not available to help you, I would suggest looking into solution #2 here -- but only if you're comfortable with running the export from the command line. If you pursue Solution #1, make sure to heed the warnings about security issues.