忘记mysql密码怎么办

 

1.停掉mysql服务

sudo /etc/init.d/mysql stop



2.忽略授权

sudo mysqld --skip-grant-tables &



3.更新密码

UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; exit;