• 登录 mysql
    mysql -u root -p
  • 重置用户密码0
    mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
  • 重置用户密码1
    mysql> use mysql;
    mysql> UPDATE user SET Password = PASSWORD('newpass') WHERE user = 'root';
    mysql> FLUSH PRIVILEGES;
  • 重置用户密码2
    mysqladmin -u root password newpassword
  • 重置用户密码3——忘记root密码
    mysqld_safe --skip-grant-tables&
    mysql -u root mysql
    mysql> UPDATE user SET password=PASSWORD("new password") WHERE user='root';
    mysql> FLUSH PRIVILEGES;
作者：bigfact