Mysql忘记root密码

Windows系统

结束/关闭mysql服务端

跳过权限表认证

mysqld --skip-grant-tables

开启新的CMD

use mysql;

update user set password = password("xxx") where user = "root";

flush pivileges;