MySQL forgot root password or error: Error 1044 (42000): Access denied for user "@ ' localhost ' to database ' xx '

Sometimes forget the root password or other user's password, login error: Error 1044 (42000): Access denied for the user "@ ' localhost ' to database ' xx '. Here are the specific workarounds:

1. Turn off MySQL

#service mysqld  Stop

2. Blocking permissions

# Mysqld_safe--skip-grant-table

3. Start a new terminal input

# mysql-u root mysql# mysql> UPDATE user SET password=password ('1234567'  where user='root'; # mysql> FLUSH privileges; // Remember to say this, otherwise if you close the previous terminal, the original error will appear # mysql> \q

This makes the setup successful.

MySQL forgot root password or error: Error 1044 (42000): Access denied for user "@ ' localhost ' to database ' xx '