MySQL Access denied

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:


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!

Read More: