In this article, we will see how to reset password for user in Azure MySQL Server. We can reset password for a user in Azure MySQL same as on-premise MySQL server.
We have two methods to reset password for a user in Azure MySQL Server.
1. Using ALTER USER command.
2. By using MySQL Workbench tool.
Reset password for user in Azure MySQL Server using ALTER USER command:
1. Connect to Azure MySQL server and run the below command to reset password for user james.
ALTER USER james@couponmysql IDENTIFIED BY 'James@123';
Reset password for user in Azure MySQL Server using MySQL Workbecnh
1. Connect to Azure MySQL server using MySQL Workbench.
2. Click on Administration tab from left menu.
3. Then click Users and Privileges
4. Then click on a user from the User and Privileges list.
5. Then click on apply.
So in this article, we have seen two different methods (gui and alter user command) to reset password for a user in Azure MySQL Server.