windows下使用下面的更新语句:

update mysql.user set authentication_string=password("123qwe") where user="root" and Host ="localhost";

ps:windows下没有password列,而是authentication_string