How to reset password for user in Azure MySQL Server

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';

How to reset password for user in Azure MySQL Server

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.

How to create Azure MySQL Database

In this article, we will see how to create Azure MySQL Database. Like MySQL on-premise server, we dont have multiple methods to create database in Azure MySQL Server. We can database in Azure MySQL server using MySQL Workbench. To create database in Azure MySQL server, logged in user must

Steps to create Azure MySQL database using GUI mode:

Continue reading How to create Azure MySQL Database

Azure MySQL FATAL Invalid Username specified Please check the Username and retry connection

In this article, we are going to find out solution for below error.

FATAL: Invalid Username specified. Please check the Username and retry connection. The Username should be in  format.

Reason for Azure MySQL FATAL Invalid Username specified Please check the Username and retry connection Continue reading Azure MySQL FATAL Invalid Username specified Please check the Username and retry connection

How to connect to Azure MySQL Database with new user from Workbench

In this article, we will see how to connect to Azure MySQL Database with new user from Workbench.

Steps to connect to Azure MySQL Database with new user from Workbench:

1. Connect to Azure portal, then click on Azure MySQL Server. From left menu click on connection security. Then, provide name for your firewall, IP address as show below. Then click on Save.

2. Open MySQL workbench.
3. Click on + symbol as as marked in the below image.
Continue reading How to connect to Azure MySQL Database with new user from Workbench

MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

In this article we are going to see solution for following error. Which occurs in MySQL when tried to create a user or change the password of MySQL user.

MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements.

MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Continue reading MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements