- 1 远程连接服务器
grant all privileges on *.* to 'root'@'ip' identified by 'root' with grant option;
- 2 修改 etc/mysql/mysql.conf.d/mysqld.cnf
# bind-address = 127.0.0.1 # 修改这一项,前面加# 自动识别所有网卡,不加# 需要把127.0.0.1修改为win的ip地址
- 3 刷新权限
flush privileges;
- 4 重启mysql服务
sudo service mysql