1 首先打开MySQL Workbench设置连接信息
查看端口
show variables like 'port';
2 Ubantu 开启MySQL服务并且开启远程连接权限
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' with grant option;
mysql>flush privileges;
3.修改mysql(ubuntu指令安装)配置文件/etc/mysql/mysql.conf.d/mysqld.cnf
将其中
bind-address = 127.0.0.1
改为
bind-address = 0.0.0.0
最后重启服务
sudo /etc/init.d/mysql restart
关闭Ubantu防火墙
sudo ufw disable