运行mysqldump后出现ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)用户名和密码都是正确的,搜索一下,看到有人说这样解决- mysql -hserverip -uroot -p

  • - mysql> update user set password=password('new password') where user='root';
  • Query OK, 4 rows affected (0.00 sec)
  • Rows matched: 4 Changed: 4 Warnings: 0
  • - mysql> flush privileges;
  • Query OK, 0 rows affected (0.00 sec)
  • - mysql> quit复制代码但是看不懂,不知道如果做,求助~