vagrant mysql 端口,无法使用HeidiSQL连接到Vagrant：“无法连接到'localhost'上的MySQL服务器”...

I'm using Scotch Box, an awesome Vagrant LAMP stack.

I was able to setup everything on my Macbook in < 5 minutes, but I'm having issues getting it working on my Windows machine.

When I try to connect to the vagrant database using the HeidiSQL client, I receive the following error:

Below are my connection settings:

I've also tried port 22 on the SSH Tunnel tab, and I've double checked my passwords:

MySQL: root/root

Vagrant: vagrant/vagrant

I've confirmed that the MySQL service is running, and I'm able to connect to MySQL via the command line when I ssh into the Vagrant instance.

Any idea why this isn't working out-of-the-box for me?

Thanks!

Edit:

Here's the Vagrantfile if it helps:

# -*- mode: ruby -*-

# vi: set ft=ruby :

Vagrant.configure("2") do |config|

config.vm.box = "scotch/box"

config.vm.network "private_network", ip: "192.168.33.10"

config.vm.hostname = "scotchbox"

config.vm.synced_folder ".", "/var/www", :mount_options => ["dmode=777", "fmode=666"]

end

解决方案

This seems to be an issue with the version of HeidiSQL I was using. Upgrading to HeidiSQL 9.1 allowed me connect.