CODEWITHSUNDEEP
azuremysqladminazure-mysql-databasemysqladministrator
Sreedhar
Sreedhar

Reputation: 30015

MySql Admin User lost Privileges

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

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

enter image description here

On Pre-Prod (which was same as Dev)

enter image description here

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.

Upvotes: 0

Views: 393

Answers (1)

Yogi
Yogi

Reputation: 9739

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

Upvotes: 0

Related Questions