linux下设置mysql远程连接;
1.阿里云开放3306端口;
2.执行:
使用 mysql 命令为 root 用户授权 mysql 远程连接服务
mysql> grant all privileges on . to ‘root’@’%’ identified by ‘root’ with grant option;
其他:
查看临时密码:
grep ‘A temporary password’ /var/log/mysqld.log
修改密码:
set password = password(‘root’)
解决密码安全性较低的问题:
set global validate_password_policy=LOW;
set global validate_password_length=4;