UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';en respectant minuscules, MAJUSCULES et espace avant WHERE.
UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N' WHERE User = 'root'; FLUSH PRIVILEGES;