1.阿里云默认没有开启3306端口,需要在安全组添加规则;
2.规则修改完后可能还会提示登陆失败,如图:
此处需要修改mysql加密方式,root为用户名,localhost为授权ip,password为密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
然后更改密码:该例子中 123为新密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123';
刷新设置:
FLUSH PRIVILEGES;