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 username and password provided in the [client] section of the/etc/mysql/debian. cnf file:
The Code is as follows: |
Copy code |
# Mysql-udebian-sys-maint-p Enter password: <Enter the password in the [client] section> Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root '; Mysql> flush privileges; Mysql> quit # Mysql-uroot-p Enter password: <Enter the new password newpassword> Mysql> |
Method 2
The Code is as follows: |
Copy code |
#/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: <Enter the new password newpassword> Mysql> |