mysql root用户 设置了密码再启动电脑之后密码失效

如题所示，每次重启电脑都要重新设置密码，很麻烦

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

命令行登录MySQL后执行上面的命令，重启MySQL服务之后还会失效吗？试试看

update user set password=password('root') where user = 'root';

commit;

flush privileges;