MySql Admin User lost Privileges

Question

On PreProd - MySqlServer Admin account lost the privileges which was all good yesterday.

When ran show grants for xxxxxadmin;on Dev its resulted as

On Pre-Prod (which was same as Dev)

There is no other admin account to log into the server. Is there a way to get the Privileges back.

These are Azure MySql databases.

Answer 1

Using Azure Portal you can reset the password.

Navigate to your Azure MySql database in Azure Portal and in Overivew, and clickReset Password.

https://learn.microsoft.com/en-us/azure/mysql/howto-create-manage-server-portal#update-admin-password