无端续集pro SSH隧道远程主机不能连接，错误的密码。

I'm new to MySQL and Vagrant and spent several hours trying to set both up. I can connect to MySQL from the command line with:

我是MySQL和流浪汉的新手，我花了好几个小时来设置。我可以从命令行连接到MySQL:

mysql --host=127.0.0.1 --user=root --password=[my_password]

I'm trying to connect with Sequel Pro and following a couple tutorials have set up Vagrant/MySQL correctly, I believe. I'm trying to connect thru SSH and tried many combinations of username/password. I believe the correct inputs are:

我正在尝试与Sequel Pro连接，并遵循了一些教程，我相信这是正确的。我尝试连接thru SSH并尝试了许多用户名/密码组合。我认为正确的输入是:

MySQL Host: 127.0.0.1

MySQL主持人:127.0.0.1

username: root

用户名:根

password: [my_password]

密码(my_password):

SSH Host: 127.0.0.1

SSH主持人:127.0.0.1

SSH User: vagrant

SSH用户:流浪的

SSH Key: insecure_private_key

SSH密钥:insecure_private_key

SSH Port: 2222

SSH端口:2222

however I'm still getting the error "The SSH Tunnel could not authenticate with the remote host. Please check your password and ensure you still have access."

但是，我仍然有错误，“SSH隧道无法与远程主机进行身份验证。请检查您的密码并确保您仍有访问权限。

Any help is appreciated, thanks

感谢您的帮助。

2 个解决方案

#1

Try the following configuration and leave everything else blank. (Of course specify MySQL root password if you've set it up.)

尝试下面的配置，并将其他所有内容保留为空。(当然，如果您已经设置了MySQL根密码，请指定。)

MySQL Host: 127.0.0.1 Username: root Port: 3306 SSH Host: 127.0.0.1 SSH User: vagrant SSH Key: ~/.vagrant.d/insecure_private_key SSH Port: 2222

MySQL主机:127.0.0.1用户名:根端口:3306 SSH主机:127.0.0.1 SSH用户:游子SSH密钥:~/.vagrant。d / insecure_private_key SSH端口:2222

#2

You need to choose SSH connection type and select the correct private key.

您需要选择SSH连接类型并选择正确的私钥。

For Vagrant 1.6 and older, the private key is located in ~/.vagrant.d/insecure_private_key. For Vagrant 1.7 and above, the private key is located in .vagrant/machines/[vm_name]/virtualbox/private_key where the Vagrantfile is located.

对于流浪1.6及以上的人，私钥位于~/.vagrant.d/insecure_private_key中。对于Vagrant 1.7和以上，私钥位于. Vagrant /machine /[vm_name]/virtualbox/private_key中，其中的流浪文件位于其中。

#1