Reset root password in MySQL

Question

I am logging in with root user in MySQL, and the server has been hardened, so this parameter is set default-authentication-plugin=caching_sha2_password, and this is currently the only user I have.

getting the following error: ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

score 1 · Accepted Answer · edited Nov 24 '23 at 16:55

1

ALTER USER 'root'@'%' IDENTIFIED WITH caching_sha2_password BY 'password';

This worked for me.

edited Nov 24 '23 at 16:55

Ergest Basha

5,369
3
7
22

answered Nov 24 '23 at 11:14

datascinalyst

105
2
11

Reset root password in MySQL

1 Answers1