mysql 忘记密码重置

[mysqld]
skip-grant-tables

use mysql;
update user set password=password('123456') where User='root';
flush privileges;

5.7以上：
use mysql;
update mysql.user set authentication_string=password('123456') where user='root';
flush privileges;