As a system administrator, there are always an embarrassed occasion that your superuser password is forgot.

Without a root password, how you can recover?

Here I consolidate my experience in dealing with this specific issue on a variety of systems.


  • stop mysql first
  • start a safe mode with option
    • mysqld_safe --skip-grant-tables &
  • update mysql.user table for user ‘root’ via mysql client
    • UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='root';
  • stop safe mode and start normal mysqld