- ifconfig查看虚拟机ip
- 主机ping 虚拟机ip需ping通
- 虚拟机进入mysql 给需要设置的用户授权grant all
grant 权限 on 数据库名.表名 to ‘用户名@ip地址’ identified by ‘用户密码’ with grant option;
如:grant all privileges on *.* to ‘ubuntu’@‘192.168.52.130’ identified by ‘123456’ with grant option; - 查看虚拟机mysql服务是否开启netstat -apn | grep 3306
- 修改mysql配置 /etc/mysql/mysql.conf.d/mysqld.cnf 注释红框内容,该句作用是只允许本地(127.0.0.1)访问
连接ubuntu16.04 MySQL
最新推荐文章于 2023-09-05 10:00:00 发布