You must SET PASSWORD before executing this statement解决

SET PASSWORD = PASSWORD('123456');