mysql - 拒绝用户 'root' @'localhost' 的访问被拒绝(使用密码 : yes) after Ubuntu Upgrade to 20. 04

Question

将我们的 Ubuntu 从 18.04 升级到 20.04 后，我无法访问我们的系统。我收到 Access Denied denied for user 'root'@'localhost' (using password: yes) .我尝试使用 mysql -u root -p输入密码后我可以连接，但是使用 mysql -u root -h 127.0.0.1 时我收到错误 access denied .
补充一下，数据库中有 3 个 root 用户，如下所示:

+------------------+-----------------+
| user             | host            |
+------------------+-----------------+
| remote           | %               |
| root             | 127.0.0.1       |
| root             | ::1             |
| debian-sys-maint | localhost       |
| mysql.session    | localhost       |
| mysql.sys        | localhost       |
| phpmyadmin       | localhost       |
| remote           | localhost       |
| root             | localhost       |
+------------------+-----------------+

Answer 1

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'YOURPWD';