vagrant - Vagrant Multimachine:如何从另一台 vagrant 机器连接到 MySQL 数据库
问题描述
流浪文件
config.vm.provision "shell", inline: "echo Hello"
config.vm.define "web" do |web|
web.vm.box = "bento/ubuntu-14.04"
web.vm.network "private_network", ip: "192.168.33.10"
web.vm.hostname = "database"
end
config.vm.define "db" do |db|
db.vm.box = "bento/ubuntu-20.04"
db.vm.network "private_network", ip: "192.168.33.11"
end
end
在 db box 上安装了 mysql-server 8,在 web box 上安装了 mysql-client。当从 web 连接到 mysql 到 db 时 mysql -u root -p -h database
出现错误ERROR 2003 (HY000): Can't connect to MySQL server on 'database' (111)
解决方案
默认情况下,mysql 仅在 localhost 上侦听。确保更改配置并绑定到 0.0.0.0 或 192.168.33.11。
请参阅:https ://serverfault.com/questions/139323/how-to-bind-mysql-server-to-more-than-one-ip-address
推荐阅读
- pandas - 你如何在 Pandas 中使用条件、聚合和连接来“透视”?
- php - wordpress 中整个页面的 ob_get_contents 以便我可以更改其内容然后输出
- java - java中根据ArrayList值调用具体方法
- python - Discord.py 嵌入消息?
- python - How to show cursor coordinate in pyqtgraph embedded in pyqt5?
- assembly - Segmentation fault (core dumped) in assembly x86-64
- ios - Host the apple association file on IIS
- html - ASP.NET I can't write into HTML Input
- javascript - React.memo and shallow comparision
- android - How to send data from Activity to Fragment?(Android)