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
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: