MYSQL客户端连接出现:client does not support authentication
MYSQL客户端连接出现:client does not support authentication
select user,host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | % |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
如果root对应的host是localhost 那下面记得换成localhost
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'xxxx(你的密码)';
FLUSH PRIVILEGES;