I forgot MySQL root password so I am trying to change it by starting it in safe mode and running following command but getting syntax error. MySQL version is 8. What is the correct syntax to update password? Or is it happening due to presence of $ and @ in password?
UPDATE mysql.user SET Password=PASSWORD('$kjD q6 MM paSSword@') WHERE User='root';
Asked by Frank Martin
(451 rep)
May 21, 2020, 04:29 PM