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.
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