r rmysql connect local database Plugin caching_sha2_password could not be loaded 1

r rmysql connect local database Plugin caching_sha2_password could not be loaded

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.

Similar Posts