怎样重置MySQL密码详解数据库

systemctl stop mysqld 
 
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables" 
 
systemctl start mysqld 
 
mysql -u root 
 
UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPassword') WHERE User = 'root' AND Host = 'localhost'; 
 
FLUSH PRIVILEGES; 
 
quit;