MySQL Set Password Error: 1064 (42000) - Correct Syntax

The correct syntax for setting a password for the root user in MySQL is:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123');

Note that there should be no space between the username and the @ symbol, and that PASSWORD should be in uppercase.