MySQL Workbench 连接虚拟机的MySQL服务器

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

最后连接成功