Cant progress-Mysql lab

im trying every possible command into mysql, neither `SET PASSWORD = PASSWORD(‘P@ssw0rd123’); or ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘P@ssw0rd123’ does not work

forgot to add “;”
delete the thread, ty


on a side note, hers another error.

To set up your password for the first time :

mysql> SET PASSWORD = PASSWORD('your_new_password');
Query OK, 0 rows affected, 1 warning (0.01 sec)

Check:
checmysql