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