MysqlERROR1045 password change methods

Currently, 1045 means that the user name and password cannot be matched, that is, the password has been forgotten. below we provide two solutions for changing the password. if you need it, please refer to it.

Currently, 1045 means that the user name and password cannot be matched, that is, the password has been forgotten. below we provide two solutions for changing the password. if you need it, please refer to it.

Directly use the user name and password provided in the [client] section of the/etc // debian. cnf file:

The code is as follows:
# Mysql-udebian-sys-maint-p Enter password: <输入[client]节的密码> Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root '; Mysql> flush privileges; Mysql> quit # Mysql-uroot-p Enter password: <输入新设的密码newpassword> Mysql>

Method 2

The code is as follows:
#/Etc/init. d/mysql stop # Mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking & # Mysql-u root mysql Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root '; Mysql> flush privileges; Mysql> quit #/Etc/init. d/mysql restart # Mysql-uroot-p Enter password: <输入新设的密码newpassword> Mysql>