Reset root password in MySQL

0 votes

1 answer

528 views

I am logging in with root user in MySQL, and the server has been hardened, so this parameter is set

-authentication-plugin=caching_sha2_password

, and this is currently the only user I have. getting the following error:

1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Asked by datascinalyst (105 rep)

Nov 24, 2023, 07:32 AM
Last activity: Nov 24, 2023, 04:55 PM