mysql 5.7修改密码

使用原来的密码登陆;

mysql -uroot -pbbbbb;
use mysql;

UPDATE mysql.user SET authentication_string = PASSWORD('aaaaaa')  WHERE user = 'root' ; 
 FLUSH PRIVILEGES;