-
Login to MySQL as Root User
mysql -u root -p
-
Change User Password
-
Syntax:-
ALTER USER <user_name>@'localhost' IDENTIFIED WITH caching_sha2_password by <user_password>;
-
Example:-
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password by 'Hello123456#';
-
-
Exit from MySQL
exit