Ubuntu20.10中连接mysql8.0时报错：Access denied for user ‘root‘@‘localhost‘

解决方案

关闭服务

service mysql stop

修改配置文件跳过grant-tables

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
---
在mysqld下面写 skip-grant-tables

[mysqld]
skip-grant-tables

启动服务登录

service mysql start

修改密码：

进入mysql数据库，查看user和host

mysql> use mysql;
mysql> select user,host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | %         |
| admin            | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| jancoyan         | localhost |
+------------------+-----------+

• 注意我的root，host是’%’，这个一定要对应起来

这样改:

-- mysql 8.0
ALTER USER 'root'@'%' IDENTIF