ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)

ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)

Generally this error is not the password is not set, is the wrong password (there may be other reasons)

Execute the following command in turn:

/etc/init.d/mysql Stop (service mysqld stop)
/usr/bin/mysqld_safe--skip-grant-tables
Also open an SSH connection
[[email protected] ~]# MySQL
Mysql>use MySQL
Mysql>update User Set Password=password ("123456") where user= "root";
Mysql>flush privileges;
Mysql>exit

Pkill-kill-t pts/0 can force a 0 * * User (previously run Mysqld_safe User window) to kick out
Normal start Mysql:/etc/init.d/mysql start (Service mysqld start)

ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)