mysql-将数据库GUI连接到Vagrant(PuPHPet)

我昨天使用PuPHPet设置了Vagrant,一切似乎都工作正常.我使用Querious连接到mysql数据库.但是,我没有保存以前用于连接的配置,并且在今天早上无所事事之后,无论做什么,我似乎都无法连接.

我正在尝试:

> SSH主机:192.168.56.101
> SSH用户:vagrant
> SSH Pass:无业游民
> SSH密钥:… / puphpet / files / dot / ssh / id_rsa
> SSH端口2222
>主机:127.0.0.1
>用户:用户名
>密码:密码
>端口:3306

如果我尝试这些设置,我会得到

> SSH failed to connect to the server 192.168.56.101 on port 2222
> 
> SSH connection failed for an unknown reason. SSH shutdown.
>
OpenSSH_6.2p2, OSSLShim 0.9.8r 8 Dec 2011
debug1: Reading configuration data /etc/ssh_config
debug1: /etc/ssh_config line 20: Applying options for *
debug1: Connecting to 192.168.56.101 [192.168.56.101] port 2222.
debug1: connect to address 192.168.56.101 port 2222: Operation timed out
ssh: connect to host 192.168.56.101 port 2222: Operation timed out

如果我将SSH主机更改为127.0.0.1,则会收到其他错误.远程主机的SSH密钥验证失败.

OpenSSH_6.2p2, OSSLShim 0.9.8r 8 Dec 2011
debug1: Reading configuration data /etc/ssh_config
debug1: /etc/ssh_config line 20: Applying options for *
debug1: Connecting to 127.0.0.1 [127.0.0.1] port 2222.
debug1: fd 3 clearing O_NONBLOCK
debug1: Connection established.
debug1: identity file /Users/db/Dev/c2t-vagrant/puphpet/files/dot/ssh/id_rsa type 1
debug1: identity file /Users/db/Dev/c2t-vagrant/puphpet/files/dot/ssh/id_rsa-cert type -1
debug1: Enabling compatibility mode for protocol 2.0
debug1: Local version string SSH-2.0-OpenSSH_6.2
debug1: Remote protocol version 2.0, remote software version OpenSSH_6.6.1p1 Ubuntu-2ubuntu2
debug1: match: OpenSSH_6.6.1p1 Ubuntu-2ubuntu2 pat OpenSSH*
debug1: SSH2_MSG_KEXINIT sent
debug1: SSH2_MSG_KEXINIT received
debug1: kex: server->client aes128-ctr hmac-md5-etm@openssh.com none
debug1: kex: client->server aes128-ctr hmac-md5-etm@openssh.com none
debug1: SSH2_MSG_KEX_DH_GEX_REQUEST(1024<1024<8192) sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_GROUP
debug1: SSH2_MSG_KEX_DH_GEX_INIT sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_REPLY
debug1: Server host key: RSA 9c:3a:9a:d0:22:8c:19:05:f2:26:54:d9:62:9e:ba:e4
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@    WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!     @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY!
Someone could be eavesdropping on you right now (man-in-the-middle attack)!
It is also possible that a host key has just been changed.
The fingerprint for the RSA key sent by the remote host is
9c:3a:9a:d0:22:8c:19:05:f2:26:54:d9:62:9e:ba:e4.
Please contact your system administrator.
Add correct host key in /Users/db/.ssh/known_hosts to get rid of this message.
Offending RSA key in /Users/db/.ssh/known_hosts:2
RSA host key for [127.0.0.1]:2222 has changed and you have requested strict checking.
Host key verification failed.

我做了“ vagrant ssh”,然后转到〜/ .ssh,其中有三个文件,授权密钥,id_rsa和id_rsa.pub. id_rsa匹配了我选择的密钥,但是我没有立即识别authorized_keys文件中的密钥.

我还尝试在php.ini中将绑定地址更改为Connect to MySQL on Vagrant instance with Sequel Pro,但我没有任何运气/不知道该怎么做.

我显然是盲目飞行,对Vagrant还是陌生的,对SSH的掌握还很不完整.接下来我应该尝试哪种类型的东西才能使它正常工作?

谢谢.

解决方法:

PuPHPet默认将端口22用于ssh.确保这是您的config.yaml所说的.

如果已更改,请确保将端口添加到防火墙.

上一篇:Vargant centOS7安装


下一篇:vagrant简介