ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
Here is what the above code is Doing:
1. We’re using the ALTER USER command to change the authentication method for the user.
2. We’re specifying the user we want to change with the username@localhost syntax.
3. We’re using the IDENTIFIED WITH mysql_native_password BY ‘password’ clause to change the authentication method to mysql_native_password and set the user’s password to password.