无法连接的原因是mysql8与mysql5的加密方式不同。
1.t通过cmd进入到mysql
2.更改加密方式:
输入:ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
注:password为你设置的本地密码
3.更改密码:
输入:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
注:password为你设置的本地密码
4.刷新:
FLUSH PRIVILEGES;