# 修改普通用户，只改一个就好
SET PASSWORD FOR 'youruser' = PASSWORD('xxxxxxxx');

# 修改root用户，改两个
SET PASSWORD FOR 'root' = PASSWORD('xxxxxxxxx');
SET PASSWORD FOR 'root'@'localhost'=PASSWORD('xxxxxxxxx');

https://www.cnblogs.com/leaderjs/p/13206915.html