修改mysql密码

use mysql;

update user set authentication_string = password('root'), password_expired = 'N', password_last_changed = now() where user = 'root';

flush privileges;

grant all privileges on *.* to 'root'@'localhost' identified by 'root';

flush privileges;

quit;

转载于:https://www.cnblogs.com/darcy-hui/p/10481579.html