MySQL ERROR 1045 Modify password two ways

Use the username and password provided directly 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 for [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 Two

code is as follows	copy code
#/etc/ Init.d/mysql Stop # mysqld_safe--user=mysql--skip-grant-tables--skip-networking & # mysql-u root MySQL br> 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 a new password Newpassword> ; Mysql>