entityMap|blocks|key|ejton|text|确保MySQL绑定到0.0.0.0而不是127.0.0.1，否则将无法从计算机外部访问它|type|unstyled|depth|inlineStyleRanges|entityRanges|data|r7f5|您可以通过编辑|4rvbg|文件并查找|6hcnp|item--您希望它看起来像这样|4g6fb|..。然后保存并重新启动MySQL：|a5397|sudo+service+mysql+restart|code-block|syntax|javascript|d4s7m|如果您在生产服务器上执行此操作，则需要了解此处讨论的安全隐患：|duhq8|https://serverfault.com/questions/257513/how-bad-is-setting-mysqls-bind-address-to-0-0-0-0^0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|T|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|U|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|V|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|W|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|X|9|@]|A|@]|B|$]]|$2|K|4|L|6|M|8|Y|9|@]|A|@]|B|$N|O]]|$2|P|4|Q|6|7|8|Z|9|@]|A|@]|B|$]]|$2|R|4|S|6|7|8|10|9|@]|A|@]|B|$]]]]

Make sure MySQL binds to 0.0.0.0 and not 127.0.0.1 or it will not be accessible from outside the machine
You can ensure this by editing the <code>/etc/mysql/my.conf</code> file and looking for the <code>bind-address</code> item--you want it to look like <code>bind-address = 0.0.0.0</code>. Then save this and restart MySQL:
<pre><code>sudo service mysql restart
</code></pre>
If you are doing this on a production server, you want to be aware of the security implications, discussed here: <a href="https://serverfault.com/questions/257513/how-bad-is-setting-mysqls-bind-address-to-0-0-0-0">https://serverfault.com/questions/257513/how-bad-is-setting-mysqls-bind-address-to-0-0-0-0</a>

entityMap|blocks|key|41cos|text|使用以下命令登录您的邮箱|type|unstyled|depth|inlineStyleRanges|entityRanges|data|7vgbc|(密码流浪)|8rv61|然后：|4pr70|并用#注释掉以下行|bjrs0|#skip-external-locking+
#bind-address|code-block|syntax|javascript|e10d|保存并退出|9drph|e877g|然后，您可以通过SSH连接到您的MySQL服务器。^0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|S|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|T|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|U|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|V|9|@]|A|@]|B|$]]|$2|I|4|J|6|K|8|W|9|@]|A|@]|B|$L|M]]|$2|N|4|O|6|7|8|X|9|@]|A|@]|B|$]]|$2|P|4|F|6|7|8|Y|9|@]|A|@]|B|$]]|$2|Q|4|R|6|7|8|Z|9|@]|A|@]|B|$]]]]

Log in to your box with <code>ssh vagrant@127.0.0.1 -p 2222</code> (password vagrant)

Then: <code>sudo nano /etc/mysql/my.cnf</code> and comment out the following lines with #

<pre><code>#skip-external-locking 
#bind-address
</code></pre>

save it &amp; exit

then: <code>sudo service mysql restart</code>

Then you can connect through SSH to your MySQL server.

entityMap|blocks|key|lat4|text|我最近遇到了这个问题。我使用PuPHPet生成配置。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3s2b6|要通过SSH连接到MySQL，“流浪者”密码对我无效，我必须通过SSH密钥文件进行身份验证。|fpokl|要连接MySQL工作台，请执行以下操作|3mouu|连接方式|9pc4h|标准TCP/IP+over+SSH|9ma8s|SSH|8kps9|Hostname:+127.0.0.1:2222+(forwarded+SSH+port)
Username:+vagrant
Password:+(do+not+use)
SSH+Key+File:+C:\vagrantpath\puphpet\files\dot\ssh\insecure_private_key
++++++++++++++(Locate+your+insercure_private_key)|code-block|syntax|javascript|930ot|MySQL|8v6f9|Server+Port:+3306
username:+(root,+or+username)
password:+(password)|emsoh|测试连接。^0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|X|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|Y|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|Z|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|10|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|11|9|@]|A|@]|B|$]]|$2|K|4|L|6|7|8|12|9|@]|A|@]|B|$]]|$2|M|4|N|6|O|8|13|9|@]|A|@]|B|$P|Q]]|$2|R|4|S|6|7|8|14|9|@]|A|@]|B|$]]|$2|T|4|U|6|O|8|15|9|@]|A|@]|B|$P|Q]]|$2|V|4|W|6|7|8|16|9|@]|A|@]|B|$]]]]

I came across this issue recently. I used PuPHPet to generate a config.

To connect to MySQL through SSH, the "vagrant" password was not working for me, instead I had to authenticate through the SSH key file.

To connect with MySQL Workbench

Connection method

Standard TCP/IP over SSH

SSH

<pre><code>Hostname: 127.0.0.1:2222 (forwarded SSH port)
Username: vagrant
Password: (do not use)
SSH Key File: C:\vagrantpath\puphpet\files\dot\ssh\insecure_private_key
 (Locate your insercure_private_key)
</code></pre>

MySQL

<pre><code>Server Port: 3306
username: (root, or username)
password: (password)
</code></pre>

Test the connection.

entityMap|blocks|key|eolsb|text|对于任何试图使用mysql工作台或sequel+pro执行此操作的人，以下是输入：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8vd5l|Mysql+Host:+192.168.56.101+(or+ip+that+you+choose+for+it)
username:+root+(or+mysql+username+u+created)
password:+****+(your+mysql+password)
database:+optional
port:+optional+(unless+you+chose+another+port,+defaults+to+3306)

ssh+host:+192.168.56.101+(or+ip+that+you+choose+for+this+vm,+like+above)
ssh+user:+vagrant+(vagrants+default+username)
ssh+password:+vagrant+(vagrants+default+password)
ssh+port:+optional+(unless+you+chose+another)|code-block|syntax|javascript|a5pdm|来源：|5laue|https://coderwall.com/p/yzwqvg^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|M|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|N|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|O|9|@]|A|@]|B|$]]]]

For anyone trying to do this using mysql workbench or sequel pro these are the inputs:

<pre><code>Mysql Host: 192.168.56.101 (or ip that you choose for it)
username: root (or mysql username u created)
password: **** (your mysql password)
database: optional
port: optional (unless you chose another port, defaults to 3306)

ssh host: 192.168.56.101 (or ip that you choose for this vm, like above)
ssh user: vagrant (vagrants default username)
ssh password: vagrant (vagrants default password)
ssh port: optional (unless you chose another)
</code></pre>

source: <a href="https://coderwall.com/p/yzwqvg">https://coderwall.com/p/yzwqvg</a>

entityMap|blocks|key|aqtul|text|好吧，由于给出的回复都对我没有帮助，所以我不得不更多地寻找，并在|type|unstyled|depth|inlineStyleRanges|entityRanges|data|66lva|这个|904k4|文章。|3trqo|简单来说，答案是：|6o0oj|使用MySQL工作台连接到MySQL|7cgbb|Connection+Method:+Standard+TCP/IP+over+SSH
SSH+Hostname:+
SSH+Username:+vagrant+(the+default+username)
SSH+Password:+vagrant+(the+default+password)
MySQL+Hostname:+127.0.0.1
MySQL+Server+Port:+3306
Username:+root
Password:|code-block|syntax|javascript|fh2n2|使用给定的方法，我能够使用mysql工作台和瓦伦蒂娜工作室从Ubuntu主机上连接到vagrant中的MySQL数据库。^0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|R|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|S|9|@]|A|@]|B|$]]|$2|E|4|F|6|7|8|T|9|@]|A|@]|B|$]]|$2|G|4|H|6|7|8|U|9|@]|A|@]|B|$]]|$2|I|4|J|6|7|8|V|9|@]|A|@]|B|$]]|$2|K|4|L|6|M|8|W|9|@]|A|@]|B|$N|O]]|$2|P|4|Q|6|7|8|X|9|@]|A|@]|B|$]]]]

Well, since neither of the given replies helped me, I had to look more, and found solution in <a href="https://slewsystems.wordpress.com/2014/01/01/connecting-to-a-puphpet-vagrant-ftp-and-mysql-servers/" rel="noreferrer">this</a> article.

And the answer in a nutshell is the following:

Connecting to MySQL using MySQL Workbench

<pre><code>Connection Method: Standard TCP/IP over SSH
SSH Hostname: &lt;Local VM IP Address (set in PuPHPet)&gt;
SSH Username: vagrant (the default username)
SSH Password: vagrant (the default password)
MySQL Hostname: 127.0.0.1
MySQL Server Port: 3306
Username: root
Password: &lt;MySQL Root Password (set in PuPHPet)&gt;
</code></pre>

Using given approach I was able to connect to mysql database in vagrant from host Ubuntu machine using MySQL Workbench and also using Valentina Studio.

entityMap|blocks|key|ank8n|text|以下是登录后对我起作用的步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4g7qi|找到MySQL配置文件：|auro6|$+mysql+--help+%7C+grep+-A+1+"Default+options"

Default+options+are+read+from+the+following+files+in+the+given+order:+/etc/my.cnf+/etc/mysql/my.cnf+~/.my.cnf|code-block|syntax|javascript|d3v82|在Ubuntu+16上，路径通常是|62tca|更改绑定地址的配置文件：|ejtog|如果存在，请按如下所示更改该值。如果它不存在，则将其添加到|6jpll|mysqld|22l2d|部分。|4as14|bind-address+=+0.0.0.0|bvsak|将更改保存到配置文件并重新启动MySQL服务。|16i34|service+mysql+restart|7mvpj|创建/授予数据库用户访问权限：|73imf|以根用户身份连接到MySQL数据库，然后运行以下SQL命令：|3qu1t|mysql>+CREATE+USER+'username'@'%25'+IDENTIFIED+BY+'password';

mysql>+GRANT+ALL+PRIVILEGES+ON+mydb.*+TO+'username'@'%25';^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|15|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|16|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|17|9|@]|A|@]|B|$H|I]]|$2|J|4|K|6|7|8|18|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|19|9|@]|A|@]|B|$]]|$2|N|4|O|6|7|8|1A|9|@]|A|@]|B|$]]|$2|P|4|Q|6|7|8|1B|9|@]|A|@]|B|$]]|$2|R|4|S|6|7|8|1C|9|@]|A|@]|B|$]]|$2|T|4|U|6|G|8|1D|9|@]|A|@]|B|$H|I]]|$2|V|4|W|6|7|8|1E|9|@]|A|@]|B|$]]|$2|X|4|Y|6|G|8|1F|9|@]|A|@]|B|$H|I]]|$2|Z|4|10|6|7|8|1G|9|@]|A|@]|B|$]]|$2|11|4|12|6|7|8|1H|9|@]|A|@]|B|$]]|$2|13|4|14|6|G|8|1I|9|@]|A|@]|B|$H|I]]]]

Here are the steps that worked for me after logging into the box:

Locate MySQL configuration file:

<pre><code>$ mysql --help | grep -A 1 "Default options"

Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
</code></pre>

On Ubuntu 16, the path is typically <code>/etc/mysql/mysql.conf.d/mysqld.cnf</code>

Change configuration file for bind-address:

If it exists, change the value as follows. If it doesn't exist, add it anywhere in the [mysqld] section.

<pre><code>bind-address = 0.0.0.0
</code></pre>

Save your changes to the configuration file and restart the MySQL service.

<pre><code>service mysql restart
</code></pre>

Create / Grant access to database user:

Connect to the MySQL database as the root user and run the following SQL commands:

<pre><code>mysql&gt; CREATE USER 'username'@'%' IDENTIFIED BY 'password';

mysql&gt; GRANT ALL PRIVILEGES ON mydb.* TO 'username'@'%';
</code></pre>

entityMap|blocks|key|6ai3i|text|这对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|e4713|在Vagrant中连接到MySQL|67cub|username:+vagrant+password:+vagrant

sudo+apt-get+update+sudo+apt-get+install+build-essential+zlib1g-dev
git-core+sqlite3+libsqlite3-dev+sudo+aptitude+install+mysql-server
mysql-client


sudo+nano+/etc/mysql/my.cnf+change:+bind-address++++++++++++=+0.0.0.0


mysql+-u+root+-p

use+mysql+GRANT+ALL+ON+*.*+to+root@'33.33.33.1'+IDENTIFIED+BY
'jarvis';+FLUSH+PRIVILEGES;+exit


sudo+/etc/init.d/mysql+restart




#+-*-+mode:+ruby+-*-
#+vi:+set+ft=ruby+:

Vagrant::Config.run+do+%7Cconfig%7C

++config.vm.box+=+"lucid32"

++config.vm.box_url+=+"http://files.vagrantup.com/lucid32.box"

++#config.vm.boot_mode+=+:gui

++#+Assign+this+VM+to+a+host-only+network+IP,+allowing+you+to+access
it+++#+via+the+IP.+Host-only+networks+can+talk+to+the+host+machine+as
well+as+++#+any+other+machines+on+the+same+network,+but+cannot+be
accessed+(through+this+++#+network+interface)+by+any+external
networks.+++#+config.vm.network+:hostonly,+"192.168.33.10"

++#+Assign+this+VM+to+a+bridged+network,+allowing+you+to+connect
directly+to+a+++#+network+using+the+host's+network+device.+This+makes
the+VM+appear+as+another+++#+physical+device+on+your+network.+++#
config.vm.network+:bridged

++#+Forward+a+port+from+the+guest+to+the+host,+which+allows+for
outside+++#+computers+to+access+the+VM,+whereas+host+only+networking
does+not.+++#+config.vm.forward_port+80,+8080

++config.vm.forward_port+3306,+3306

++config.vm.network+:hostonly,+"33.33.33.10"


end|code-block|syntax|javascript^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|J|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|K|9|@]|A|@]|B|$]]|$2|E|4|F|6|G|8|L|9|@]|A|@]|B|$H|I]]]]

This worked for me: <a href="https://gist.github.com/johnantoni/3288329" rel="nofollow noreferrer">Connect to MySQL in Vagrant</a>

<pre><code>username: vagrant password: vagrant

sudo apt-get update sudo apt-get install build-essential zlib1g-dev
git-core sqlite3 libsqlite3-dev sudo aptitude install mysql-server
mysql-client


sudo nano /etc/mysql/my.cnf change: bind-address = 0.0.0.0


mysql -u root -p

use mysql GRANT ALL ON *.* to root@'33.33.33.1' IDENTIFIED BY
'jarvis'; FLUSH PRIVILEGES; exit


sudo /etc/init.d/mysql restart




# -*- mode: ruby -*-
# vi: set ft=ruby :

Vagrant::Config.run do |config|

 config.vm.box = "lucid32"

 config.vm.box_url = "http://files.vagrantup.com/lucid32.box"

 #config.vm.boot_mode = :gui

 # Assign this VM to a host-only network IP, allowing you to access
it # via the IP. Host-only networks can talk to the host machine as
well as # any other machines on the same network, but cannot be
accessed (through this # network interface) by any external
networks. # config.vm.network :hostonly, "192.168.33.10"

 # Assign this VM to a bridged network, allowing you to connect
directly to a # network using the host's network device. This makes
the VM appear as another # physical device on your network. #
config.vm.network :bridged

 # Forward a port from the guest to the host, which allows for
outside # computers to access the VM, whereas host only networking
does not. # config.vm.forward_port 80, 8080

 config.vm.forward_port 3306, 3306

 config.vm.network :hostonly, "33.33.33.10"


end
</code></pre>

I mounted a new VirtualBox Machine with Vagrant, and inside that VM I installed Mysql Server. How can I connect to that server outside the vm? I already forward the port 3306 of the Vagrantfile , but when I try to connect to the mysql server, it`s resposts with the error: 
'reading initial communication packet'

<pre><code>ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
</code></pre>

How to connect to Mysql Server inside VirtualBox Vagrant?

身份验证

SQL数据库

SQL Server

数据库

服务器

虚拟机

Ubuntu

MySQL

 我使用Vagrant挂载了一台新的VirtualBox机器，并在该虚拟机中安装了Mysql Server。如何连接到vm外部服务器？我已经转发了Vagrantfile的端口3306，但当我尝试连接到mysql服务器时，它重新发送了错误消息：‘正在读取初始通信数据包’ ERROR 2013 (HY000): Lost connection to MySQL server at 'reading i

问如何在VirtualBox Vagrant中连接到Mysql Server？
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在VirtualBox Vagrant中连接到Mysql Server？EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在VirtualBox Vagrant中连接到Mysql Server？
EN