blocks|key|1953534|text|您通常需要的凭据/信息：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1953535|IP地址192.168.10.10+(查看您的宅基地Folder>Homestead.yaml)|unordered-list-item|1953536|端口:+3306|1953537|用户:宅地(全小写)|1953538|-秘密|1953539|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|O|8|@]|9|@]|A|$]]|$1|G|3|H|5|D|7|P|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Q|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|L|$]]

The usual credentials/info you need:

<ul>
<li>IP address 192.168.10.10 (Check your Homestead Folder>Homestead.yaml)</li>
<li>Port: 3306</li>
<li>User: homestead (all lowercase)</li>
<li>Pw: secret</li>
</ul>

blocks|key|1382089|text|根据正式文件，您应该使用端口33060而不是3306个。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1382090|还应该相应地更新.env文件，因此在运行第一次迁移时不会出现问题，因为Laravel安装在虚拟机中运行，您需要那里的默认端口3306。|1382091|entityMap|0|LINK|mutability|MUTABLE|url|https://laravel.com/docs/5.2/homestead#connecting-to-databases^0|2|4|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

You should be using the port 33060 instead of 3306 according to the <a href="https://laravel.com/docs/5.2/homestead#connecting-to-databases" rel="noreferrer">official documentation</a>.

The .env file should also be updated accordingly, so you won't have issues when running your first migration, as the Laravel installation is running inside the virtual machine you need the default port 3306 there.

blocks|key|1953475|text|MySQL正式文件显示|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1953476|无法连接到“服务器”(10061)上的MySQL服务器的错误(2003年)表示网络连接已被拒绝。您应该检查是否有一个MySQL服务器正在运行，它是否启用了网络连接，并且您指定的网络端口是否是在服务器上配置的。|blockquote|1953477|您正在尝试使用虚拟IP访问另一台计算机中的MySQL服务器。我会用我的IP让你更好地理解。|1953478|我的主机有两个IP：|1953479|实际IP为192.168.0.53|unordered-list-item|1953480|虚拟IP为192.168.10.1|1953481|您可以看到您的主机IP正在Windows机器中执行|1953482|ipconfig+|code-block|syntax|javascript|1953483|在Unix机器上|1953484|ifconfig+|1953485|您必须使用|1953486|vagrant+ssh|1953487|那你就得执行|1953488|ifconfig|1953489|查看虚拟机的IP。|1953490|在我的Vagrant中，IP是：|1953491|10.0.2.15|1953492|192.168.10.10|1953493|您可以看到，我在主机(192.168.10.1)中有一个IP，在同一个LAN中有一个Vagrant+(192.168.10.10)。|1953494|Vagrant+(在我的示例中是192.168.10.10)是您必须在MySQL客户机中使用的。|1953495|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html^0|0|9|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1S|8|@]|9|@$A|1T|B|1U|1|1V]]|C|$]]|$1|D|3|E|5|F|7|1W|8|@]|9|@]|C|$]]|$1|G|3|H|5|6|7|1X|8|@]|9|@]|C|$]]|$1|I|3|J|5|6|7|1Y|8|@]|9|@]|C|$]]|$1|K|3|L|5|M|7|1Z|8|@]|9|@]|C|$]]|$1|N|3|O|5|M|7|20|8|@]|9|@]|C|$]]|$1|P|3|Q|5|6|7|21|8|@]|9|@]|C|$]]|$1|R|3|S|5|T|7|22|8|@]|9|@]|C|$U|V]]|$1|W|3|X|5|6|7|23|8|@]|9|@]|C|$]]|$1|Y|3|Z|5|T|7|24|8|@]|9|@]|C|$U|V]]|$1|10|3|11|5|6|7|25|8|@]|9|@]|C|$]]|$1|12|3|13|5|T|7|26|8|@]|9|@]|C|$U|V]]|$1|14|3|15|5|6|7|27|8|@]|9|@]|C|$]]|$1|16|3|17|5|T|7|28|8|@]|9|@]|C|$U|V]]|$1|18|3|19|5|6|7|29|8|@]|9|@]|C|$]]|$1|1A|3|1B|5|6|7|2A|8|@]|9|@]|C|$]]|$1|1C|3|1D|5|M|7|2B|8|@]|9|@]|C|$]]|$1|1E|3|1F|5|M|7|2C|8|@]|9|@]|C|$]]|$1|1G|3|1H|5|6|7|2D|8|@]|9|@]|C|$]]|$1|1I|3|1J|5|6|7|2E|8|@]|9|@]|C|$]]|$1|1K|3|-4|5|6|7|2F|8|@]|9|@]|C|$]]]|1L|$1M|$5|1N|1O|1P|C|$1Q|1R]]]]

The <a href="http://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html" rel="nofollow">MySQL official documentation</a> shows 

<blockquote>
 The error (2003) Can't connect to MySQL server on 'server' (10061)
 indicates that the network connection has been refused. You should
 check that there is a MySQL server running, that it has network
 connections enabled, and that the network port you specified is the
 one configured on the server.
</blockquote>

You are trying to access to a MySQL server in another machine, with a virtual IP. I will use my IP's so you can understand better.

My host machine has 2 IP:

<ul>
<li>the real IP is 192.168.0.53 </li>
<li>the virtual IP is 192.168.10.1</li>
</ul>

You can see your host machine IP's executing in a Windows machine

<pre><code>ipconfig 
</code></pre>

and in a Unix machine

<pre><code>ifconfig 
</code></pre>

You have to login to the Vagrant machine using 

<pre><code>vagrant ssh
</code></pre>

Then you have to execute 

<pre><code>ifconfig
</code></pre>

to see the IP's of the virtual machine.

In my Vagrant VM the IP are:

<ul>
<li>10.0.2.15</li>
<li>192.168.10.10</li>
</ul>

You can see that I have one IP in the host machine (192.168.10.1) and one in the Vagrant VM (192.168.10.10) in the same LAN.

The Vagrant VM IP (192.168.10.10 in my example) is the one you have to use in your MySQL client.

blocks|key|2706336|text|Homestead说，应该使用address+127.0.0.1端口33060进行连接。我做了个测试，结果成功了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2706337|为MySQL和PostgreSQL配置了开箱即用的宅基地数据库。要从主机的数据库客户端连接到MySQL或PostgreSQL数据库，您应该连接到127.0.0.1和端口33060+(MySQL)或54320+(PostgreSQL)。这两个数据库的用户名和密码都是住宅/机密。|blockquote|2706338|来源：https://laravel.com/docs/5.8/homestead#configuring-homestead|offset|length|2706339|entityMap|0|LINK|mutability|MUTABLE|url|https://laravel.com/docs/5.8/homestead#configuring-homestead^0|0|0|3|1O|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$]]|$1|E|3|F|5|6|7|S|8|@]|9|@$G|T|H|U|1|V]]|A|$]]|$1|I|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

The Homestead documentation says that you should use address 127.0.0.1 port 33060 to connect. I made a test and it worked.

<blockquote>
 A homestead database is configured for both MySQL and PostgreSQL out of the box. To connect to your MySQL or PostgreSQL database from your host machine's database client, you should connect to 127.0.0.1 and port 33060 (MySQL) or 54320 (PostgreSQL). The username and password for both databases is homestead / secret.
</blockquote>

Source: <a href="https://laravel.com/docs/5.8/homestead#configuring-homestead" rel="nofollow noreferrer">https://laravel.com/docs/5.8/homestead#configuring-homestead</a>

blocks|key|1953588|text|​|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1953589|第一页(Instelligen)：|1953590|1953591|IP地址:您在Homestead.yaml文件中定义的IP+(我的是:+192.168.10.10)|unordered-list-item|offset|length|style|CODE|1953592|用户名:宅地|1953593|密码:秘密|1953594|第二个标签(SSH)：|1953595|IP地址-与第一个选项卡相同|1953596|用户名:流浪汉|1953597|密码:流浪汉|1953598|其他一切都要保持原样。这对我有用。我使用的是相同的HeidiSQL程序。|1953599|entityMap^0|0|0|0|7|E|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@]|9|@]|A|$]]|$1|D|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|14|8|@$H|15|I|16|J|K]]|9|@]|A|$]]|$1|L|3|M|5|G|7|17|8|@]|9|@]|A|$]]|$1|N|3|O|5|G|7|18|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|19|8|@]|9|@]|A|$]]|$1|R|3|S|5|G|7|1A|8|@]|9|@]|A|$]]|$1|T|3|U|5|G|7|1B|8|@]|9|@]|A|$]]|$1|V|3|W|5|G|7|1C|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1D|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|10|$]]

<h3>First tab (Instelligen): </h3>

<ul>
<li>IP Address: the IP that you defined in the <code>Homestead.yaml</code> file (mine is: 192.168.10.10)</li>
<li>Username: homestead</li>
<li>Password: secret</li>
</ul>

<h3>Second tab (SSH): </h3>

<ul>
<li>IP Address - same as on the first tab</li>
<li>Username: vagrant</li>
<li>Password: vagrant</li>
</ul>

Leave everything else the same. This worked for me. I'm using the same HeidiSQL program.

blocks|key|1953609|text|官方医生|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1953610|1：https://laravel.com/docs/5.8/homestead#connecting-to-databases奉命使用端口33060表示MySQL，使用54320表示PostgreSQL|offset|length|style|CODE|1953611|为MySQL和PostgreSQL配置了开箱即用的宅基地数据库。要从主机的数据库客户端连接到MySQL或PostgreSQL数据库，您应该连接端口33060+(MySQL)或54320+(PostgreSQL)上的127.0.0.1。这两个数据库的用户名和密码都是住宅/机密。|blockquote|1953612|entityMap|0|LINK|mutability|MUTABLE|url|https://laravel.com/docs/5.8/homestead#connecting-to-databases^0|0|1Y|5|2D|5|2|1Q|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@$D|U|E|V|F|G]|$D|W|E|X|F|G]]|9|@$D|Y|E|Z|1|10]]|A|$]]|$1|H|3|I|5|J|7|11|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

[Official Doc][1]
[1]: <a href="https://laravel.com/docs/5.8/homestead#connecting-to-databases" rel="nofollow noreferrer">https://laravel.com/docs/5.8/homestead#connecting-to-databases</a> is instructed to use port <code>33060</code> for MySQL and <code>54320</code> for PostgreSQL
<blockquote>
A homestead database is configured for both MySQL and PostgreSQL out of the box. To connect to your MySQL or PostgreSQL database from your host machine's database client, you should connect to 127.0.0.1 on port 33060 (MySQL) or 54320 (PostgreSQL). The username and password for both databases is homestead / secret.
</blockquote>

I just created a fresh laravel project and I'm using a Homestead vagrant box by running

<blockquote>
 vagrant init laravel/homestead
</blockquote>

and after

<blockquote>
 Vagrant Up
</blockquote>

When I use <code>vagrant ssh</code> it gives me no problem and I can acces the vagrant box, however when I want to connect to the DB with Heidisql I get a connection error:

<blockquote>
 can't connect to mysql server on 'localhost' (10061)
</blockquote>

Here's my setup

<a href="https://i.stack.imgur.com/vMO1x.png" rel="noreferrer"><img src="https://i.stack.imgur.com/vMO1x.png" alt="enter image description here"></a>
<a href="https://i.stack.imgur.com/tohxr.png" rel="noreferrer"><img src="https://i.stack.imgur.com/tohxr.png" alt="enter image description here"></a>

the password I'm using = "secret"

Homestead - Connecting to my database

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我刚刚创建了一个新的laravel项目，我通过运行迷途夜莺/家园之后流浪汉当我使用vagrant ssh时，它不会给我带来任何问题，而且我可以访问“流浪”框，但是，当我想用连接到DB时，我会得到一个连接错误：无法连接到“localhost”上的mysql服务器(10061)这是我的装置​​我使用的密码=“秘密”

问宅基地-连接到我的数据库
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问宅基地-连接到我的数据库EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问宅基地-连接到我的数据库
EN