reset password for Linux ERROR 1045 (28000): Access denied for user ‘root’ @’ localhost ‘(using password: YES)
usually this ERROR is caused by a password ERROR, so the solution is naturally to reset the password.
suppose we are using a root account.
1. The first step to reset your password is to skip the MySQL password authentication process as follows:
#vim /etc/my.cnf(note: my.ini is modified under Windows)
search mysqld within the document to locate the [mysqld] text segment:
/mysqld(directly enter this command to search text content in vim edit state)
add “skip-gran-tables” on any line after [mysqld] to skip the password verification process, as shown in the figure below:
save the document and exit:
#:wq
2. Next we need to restart MySQL:
/etc/init.d/mysql restart(some users may need to use /etc/init.d/mysqld restart)
3. After a reboot enter #mysql to enter mysql.
4. The next step is to use SQL to change root’s password
mysql> use mysql;
mysql> Update user set password=password(” your new password “) where user= “root”;
mysql> flush privileges;
mysql> quit
is where the root account has been reset to the new password.
5. Edit my.cnf to remove the content you just added, and then restart MySQL. There we go!