ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

先执行：

flush privileges;

再执行修改密码命令，可以了：

set password for root@localhost=password('你的密码');