mysql5.7修改密码

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

mysql> alter user 'root'@'localhost' identified by '123';

mysql> set password for 'root'@'localhost'=password('123');
mysql> flush privileges;