You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED WITH mysql_native_password BY '123456'' at line 1

I apologize for the confusion. It seems there was an error in the syntax I provided. If you encounter the error message "You have an error in your SQL syntax...", please try the following command instead to set the password for MySQL 5.6:

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

Replace `'new_password'` with the actual password you want to set. After executing this command, the root password should be updated successfully.

Remember to use a strong password and keep it secure.