blocks|key|4685202|text|该错误消息指示尝试通过套接字进行MySQL连接(不支持)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4685203|在Laravel+(工匠)的上下文中，您可能希望使用不同的/正确的环境。例如：php+artisan+migrate+--env=production+(或其他任何环境)。参见here。|offset|length|style|CODE|4685204|entityMap|0|LINK|mutability|MUTABLE|url|http://laravel.com/docs/artisan#usage^0|0|13|10|2G|4|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@$D|R|E|S|F|G]]|9|@$D|T|E|U|1|V]]|A|$]]|$1|H|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

The error message indicates that a MySQL connection via socket is tried (which is not supported).

In the context of Laravel (artisan), you probably want to use a different / the correct environment. Eg: <code>php artisan migrate --env=production</code> (or whatever environment). See <a href="http://laravel.com/docs/artisan#usage" rel="noreferrer">here</a>.

blocks|key|179275|text|由于另一个原因，我遇到了[PDOException]+SQLSTATE[HY000]+[2002]+No+such+file+or+directory错误。我刚刚使用Apache2.4.7、PHPV5.5.10和MySQL+5.6.16在Ubuntu12.04上构建了一个全新的LAMP堆栈。我把我的网站移了回来，启动了它们。但是，由于上面的[PDOException]，我无法加载基于Laravel+4.2.x的站点。因此，我查看了php+-i+%7C+grep+pdo，并注意到这一行：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|179276|pdo_mysql.default_socket+=>+/tmp/mysql.sock+=>+/tmp/mysql.sock|code-block|syntax|javascript|179277|但是，在我的/etc/my.cnf中，sock文件实际上是在/var/run/mysqld/mysqld.sock中。|179278|因此，我打开我的php.ini并设置pdo_mysql.default_socket的值|179279|pdo_mysql.default_socket=/var/run/mysqld/mysqld.sock|179280|然后，我重启apache并检查php+-i+%7C+grep+pdo|179281|pdo_mysql.default_socket+=>+/var/run/mysqld/mysqld.sock+=>+/var/run/mysqld/mysqld.sock|179282|帮我修好了。|179283|entityMap^0|C|1R|4R|E|61|H|0|0|U|R|0|I|O|0|0|F|H|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|15|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|19|8|@$9|1A|A|1B|B|C]]|D|@]|E|$]]|$1|O|3|P|5|H|7|1C|8|@]|D|@]|E|$I|J]]|$1|Q|3|R|5|6|7|1D|8|@$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|S|3|T|5|H|7|1G|8|@]|D|@]|E|$I|J]]|$1|U|3|V|5|6|7|1H|8|@]|D|@]|E|$]]|$1|W|3|-4|5|6|7|1I|8|@]|D|@]|E|$]]]|X|$]]

I encountered the <code>[PDOException] SQLSTATE[HY000] [2002] No such file or directory</code> error for a different reason. I had just finished building a brand new LAMP stack on Ubuntu 12.04 with Apache 2.4.7, PHP v5.5.10 and MySQL 5.6.16. I moved my sites back over and fired them up. But, I couldn't load my Laravel 4.2.x based site because of the <code>[PDOException]</code> above. So, I checked <code>php -i | grep pdo</code> and noticed this line:

<pre><code>pdo_mysql.default_socket =&gt; /tmp/mysql.sock =&gt; /tmp/mysql.sock
</code></pre>

But, in my /etc/my.cnf the sock file is actually in <code>/var/run/mysqld/mysqld.sock</code>.

So, I opened up my php.ini and set the value for <code>pdo_mysql.default_socket</code>:

<pre><code>pdo_mysql.default_socket=/var/run/mysqld/mysqld.sock
</code></pre>

Then, I restarted apache and checked <code>php -i | grep pdo</code>:

<pre><code>pdo_mysql.default_socket =&gt; /var/run/mysqld/mysqld.sock =&gt; /var/run/mysqld/mysqld.sock
</code></pre>

That fixed it for me.

blocks|key|179325|text|在我的例子中，我一点问题都没有，只是忘记启动mysql服务……|type|unstyled|depth|inlineStyleRanges|entityRanges|data|179326|sudo+service+mysqld+start|code-block|syntax|javascript|179327|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

In my case i had no problem at all, just forgot to start the mysql service...

<pre><code>sudo service mysqld start
</code></pre>

blocks|key|179358|text|如果您使用的是Laravel+Homestead，请确保调用的是服务器上的命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|179359|homestead+ssh|code-block|syntax|javascript|179360|然后，只需cd到正确的目录，并在那里执行您的命令。|179361|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

If you are using Laravel Homestead, make sure you're calling the commands on the server.

<pre><code>homestead ssh
</code></pre>

Then simply cd to the right directory and fire your command there.

blocks|key|4686076|text|当我在.env文件中从DB_HOST=localhost更改为DB_HOST=127.0.0.1后，它工作了|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4686077|entityMap^0|B|H|V|H|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

It worked after I change from <code>DB_HOST=localhost</code> to <code>DB_HOST=127.0.0.1</code> at .env file

blocks|key|179866|text|在database.php文件中添加mysql.sock路径，如下所示|type|unstyled|depth|inlineStyleRanges|entityRanges|data|179867|'unix_socket'+=>+'/Applications/MAMP/tmp/mysql/mysql.sock',|code-block|syntax|javascript|179868|示例|179869|'mysql'+=>+[
++++++++'driver'+=>+'mysql',
++++++++'unix_socket'+=>+'/Applications/MAMP/tmp/mysql/mysql.sock',
++++++++'host'+=>+env('DB_HOST',+'localhost'),
++++++++'port'+=>+env('DB_PORT',+'8889'),|179870|entityMap^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|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Add mysql.sock path in database.php file like below example

<pre><code>'unix_socket' =&gt; '/Applications/MAMP/tmp/mysql/mysql.sock',
</code></pre>

Eample 

<pre><code>'mysql' =&gt; [
 'driver' =&gt; 'mysql',
 'unix_socket' =&gt; '/Applications/MAMP/tmp/mysql/mysql.sock',
 'host' =&gt; env('DB_HOST', 'localhost'),
 'port' =&gt; env('DB_PORT', '8889'),
</code></pre>

blocks|key|4685800|text|Mamp用户启用选项允许对MYSQL进行网络访问|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4685801|​|4685802|📷|atomic|offset|length|4685803|4685804|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/d15427b78b9fddcfc7d984ab61d48cb0.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

Mamp user enable option Allow network access to MYSQL

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

blocks|key|4685290|text|基于@dcarrith的答案...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4685291|我没有编辑配置文件，而是在PHP正在查找的位置创建了一个别名，该别名连接到真正的mysql.sock。(source)|offset|length|4685292|只需运行这两个命令(无需重启)：|4685293|mkdir+/var/mysql
ln+-s+/tmp/mysql.sock+/var/mysql/mysql.sock|code-block|syntax|javascript|4685294|entityMap|0|LINK|mutability|MUTABLE|url|https://serverfault.com/a/228702/196015^0|0|1G|6|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@$D|W|E|X|1|Y]]|A|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

Building on the answer from @dcarrith ...

Instead of editing the config files, I created an alias in the location that PHP is looking that connects to the real mysql.sock. (<a href="https://serverfault.com/a/228702/196015">source</a>)

Just run these two commands (no restart needed):

<pre><code>mkdir /var/mysql
ln -s /tmp/mysql.sock /var/mysql/mysql.sock
</code></pre>

blocks|key|179572|text|我在MAMP+Pro上运行，在尝试迁移(创建数据库表)时遇到了类似的问题。我也尝试了其中的一些建议，但并不适合我。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|179573|因此，简单地(搜索了一个小时之后)，我在/config/database.php中添加了两项内容。|179574|'port'+=>+'1234',
'unix_socket'+=>+'/path/to/my/socket/mysqld.sock'|code-block|syntax|javascript|179575|现在可以正常工作了！|179576|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I'm running on MAMP Pro and had this similar problem when trying to migrate (create db tables). Tried a few of these mentioned suggestions as well but didn't do it for me. 

So, simply (after an hour googling), I added two things to the /config/database.php.

<pre><code>'port' =&gt; '1234',
'unix_socket' =&gt; '/path/to/my/socket/mysqld.sock'
</code></pre>

Works fine now!

blocks|key|180035|text|当我使用docker容器运行我的应用程序时，我遇到了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|180036|解决方案是将我在docker_compose.yml中使用的MySQL服务容器的名称放在DB_HOST上。在我的例子中，它是db：|offset|length|style|CODE|180037|DB_HOST=db|code-block|syntax|javascript|180038|希望能有所帮助。|180039|entityMap^0|0|8|I|1Q|2|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]|$D|U|E|V|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|W|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

I had this problems when I was running my application using docker containers. 

The solution was put the name of the MySQL service container I was using in <code>docker_compose.yml</code> on DB_HOST. In my case, it was <code>db</code> :

<pre><code>DB_HOST=db
</code></pre>

Hope it helps.

blocks|key|179512|text|我在访问我的Drupal网站时遇到了类似的问题。我通过打开命令行并重新启动我的MySQL服务器或服务来修复它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|179513|service+mysqld+restart|code-block|syntax|javascript|179514|这应该是可行的。如果没有，请重新启动本地your服务器：|179515|service+httpd+restart|179516|这应该足够了。希望它也适用于其他环境。请注意，这些命令通常需要超级用户权限。|179517|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I had similar problems accessing my Drupal website. I fixed it by opening the command line, and restarting my MySQL server or service:

<pre><code>service mysqld restart
</code></pre>

This should work. If it doesn't, restart your local webserver:

<pre><code>service httpd restart
</code></pre>

That should be enough. Hope it works for other environments, too. Note that these commands generally require superuser privileges.

blocks|key|179639|text|当我在Elixir/Gulp中运行PHPUnit，并将Homestead作为我的流浪环境时，我遇到了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|179640|在我的示例中，我将.env文件从DB_HOST=localhost编辑为DB_HOST=192.168.10.10，其中192.168.10.10是我的Vagrant/Homestead主机的IP。|offset|length|style|CODE|179641|entityMap^0|0|G|H|10|L|1O|D|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]|$D|N|E|O|F|G]|$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|I|$]]

I ran into this problem when running PHPUnit in Elixir/Gulp, and Homestead as my Vagrant enviroment.

In my case I edited the .env file from <code>DB_HOST=localhost</code> to <code>DB_HOST=192.168.10.10</code> where <code>192.168.10.10</code> is the IP of my Vagrant/Homestead host.

blocks|key|179905|text|仔细检查您的端口。在我的例子中是8889，我使用的是8888。将"DB_HOST“从"localhost”更改为"127.0.0.1“，反之亦然|type|unstyled|depth|inlineStyleRanges|entityRanges|data|179906|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Check your port carefully . In my case it was 8889 and i am using 8888. 
change "DB_HOST" from "localhost" to "127.0.0.1" and vice versa

blocks|key|4686267|text|我在docker_compose.yml文件中使用Docker和MySQL服务名称db时也遇到了同样的问题：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4686268|我在.env文件中添加了以下内容：|4686269|DB_HOST=db|code-block|syntax|javascript|4686270|您还应该确保可以从php应用程序中发现您的主机。|4686271|这是因为PHP不知道使用哪台主机进行连接。|4686272|entityMap^0|15|2|0|2|4|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|V|8|@$9|W|A|X|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|Y|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|Z|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|10|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|11|8|@]|D|@]|E|$]]]|R|$]]

I had the same problem using Docker and MySQL service name <code>db</code> in docker_compose.yml file:

I added the following in the <code>.env</code> file:

<pre><code>DB_HOST=db
</code></pre>

you should also assure that your host is discoverable from the php app.

It was because PHP didn't figure out which host to use to connect.

blocks|key|180219|text|我在ubuntu+18.04和nginx上也遇到了同样的问题。通过以下步骤，我的问题已经得到解决：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|180220|首先打开终端，进入mysql+CLI。为了检查mysql套接字的位置，我编写了以下命令。|180221|mysql>+show+variables+like+'%25sock%25'|code-block|syntax|javascript|180222|我得到了类似下面这样的东西：|180223|%2B-----------------------------------------%2B-----------------------------%2B
%7C+Variable_name+++++++++++++++++++++++++++%7C+Value+++++++++++++++++++++++%7C
%2B-----------------------------------------%2B-----------------------------%2B
%7C+mysqlx_socket+++++++++++++++++++++++++++%7C+/var/run/mysqld/mysqlx.sock+%7C
%7C+performance_schema_max_socket_classes+++%7C+10++++++++++++++++++++++++++%7C
%7C+performance_schema_max_socket_instances+%7C+-1++++++++++++++++++++++++++%7C
%7C+socket++++++++++++++++++++++++++++++++++%7C+/var/run/mysqld/mysqld.sock+%7C
%2B-----------------------------------------%2B-----------------------------%2B
4+rows+in+set+(0.00+sec)|180224|在laravel项目文件夹中，在database.php文件夹中查找配置文件。在mysql部分，我根据上表修改了unix_socket。|180225|'mysql'+=>+array(
++++++++'driver'++++=>+'mysql',
++++++++'host'++++++=>+'127.0.0.1',
++++++++'database'++=>+'database_name',
++++++++'username'++=>+'username',
++++++++'password'++=>+'password',
++++++++'charset'+++=>+'utf8',
++++++++'collation'+=>+'utf8_unicode_ci',
++++++++'prefix'++++=>+'',
++++++++'unix_socket'+=>+'/var/run/mysqld/mysqld.sock',
++++),|180226|现在只需保存更改，并重新加载页面，它就可以工作了。|180227|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

I got the same problem in ubuntu 18.04 with nginx. By following the below steps my issue has been fixd:
First open terminal and enter into mysql CLI. To check mysql socket location I write the following command.
<pre><code>mysql&gt; show variables like '%sock%'
</code></pre>
I got something like the below :
<pre><code>+-----------------------------------------+-----------------------------+
| Variable_name | Value |
+-----------------------------------------+-----------------------------+
| mysqlx_socket | /var/run/mysqld/mysqlx.sock |
| performance_schema_max_socket_classes | 10 |
| performance_schema_max_socket_instances | -1 |
| socket | /var/run/mysqld/mysqld.sock |
+-----------------------------------------+-----------------------------+
4 rows in set (0.00 sec)
</code></pre>
In laravel project folder, look for the database.php file in the config folder. In the mysql section I modified unix_socket according to the above table.
<pre><code>'mysql' =&gt; array(
 'driver' =&gt; 'mysql',
 'host' =&gt; '127.0.0.1',
 'database' =&gt; 'database_name',
 'username' =&gt; 'username',
 'password' =&gt; 'password',
 'charset' =&gt; 'utf8',
 'collation' =&gt; 'utf8_unicode_ci',
 'prefix' =&gt; '',
 'unix_socket' =&gt; '/var/run/mysqld/mysqld.sock',
 ),
</code></pre>
Now just save changes, and reload the page and it worked.

blocks|key|179403|text|从Laravel+5开始，数据库用户名和密码放在项目目录中的.env文件中，例如|type|unstyled|depth|inlineStyleRanges|entityRanges|data|179404|DB_HOST=127.0.0.1
DB_DATABASE=db1
DB_USERNAME=user1
DB_PASSWORD=pass1|code-block|syntax|javascript|179405|正如您所看到的，这些环境变量在这里覆盖了'forge‘字符串，所以更改它们没有任何效果：|179406|++++'mysql'+=>+[
++++++++'driver'++++=>+'mysql',
++++++++'host'++++++=>+env('DB_HOST',+'localhost'),
++++++++'database'++=>+env('DB_DATABASE',+'forge'),
++++++++'username'++=>+env('DB_USERNAME',+'forge'),
++++++++'password'++=>+env('DB_PASSWORD',+''),
++++++++'charset'+++=>+'utf8',
++++++++'collation'+=>+'utf8_unicode_ci',
++++++++'prefix'++++=>+'',
++++++++'strict'++++=>+false,
++++],|179407|更多信息请点击此处https://mattstauffer.co/blog/laravel-5.0-environment-detection-and-environment-variables|offset|length|179408|entityMap|0|LINK|mutability|MUTABLE|url|https://mattstauffer.co/blog/laravel-5.0-environment-detection-and-environment-variables^0|0|0|0|0|9|2G|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@]|9|@$M|11|N|12|1|13]]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

As of Laravel 5 the database username and password goes in the .env file that exists in the project directory, e.g.

<pre><code>DB_HOST=127.0.0.1
DB_DATABASE=db1
DB_USERNAME=user1
DB_PASSWORD=pass1
</code></pre>

As you can see these environment variables are overriding the 'forge' strings here so changing them has no effect:

<pre><code> 'mysql' =&gt; [
 'driver' =&gt; 'mysql',
 'host' =&gt; env('DB_HOST', 'localhost'),
 'database' =&gt; env('DB_DATABASE', 'forge'),
 'username' =&gt; env('DB_USERNAME', 'forge'),
 'password' =&gt; env('DB_PASSWORD', ''),
 'charset' =&gt; 'utf8',
 'collation' =&gt; 'utf8_unicode_ci',
 'prefix' =&gt; '',
 'strict' =&gt; false,
 ],
</code></pre>

More information is here <a href="https://mattstauffer.co/blog/laravel-5.0-environment-detection-and-environment-variables" rel="nofollow">https://mattstauffer.co/blog/laravel-5.0-environment-detection-and-environment-variables</a>

blocks|key|179678|text|尝试连接到localhost：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|179679|SQLSTATE[HY000]+[2002]+No+such+file+or+directory|code-block|syntax|javascript|179680|尝试连接到127.0.0.1：|179681|SQLSTATE[HY000]+[2002]+Connection+refused|179682|好的，只需注释/删除my.cnf+(在OS+X+10.5：/opt/local/etc/mysqlxx/my.cnf上)中的以下设置即可获得：|offset|length|style|CODE|179683|[mysqld]
#+skip-networking|179684|当然，请停止并启动MySQL服务器。|179685|entityMap^0|0|0|0|0|T|T|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@$M|11|N|12|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|14|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

Attempt to connect to localhost:

<pre><code>SQLSTATE[HY000] [2002] No such file or directory
</code></pre>

Attempt to connect to 127.0.0.1:

<pre><code>SQLSTATE[HY000] [2002] Connection refused
</code></pre>

OK, just comment / remove the following setting from my.cnf (on OS X 10.5: <code>/opt/local/etc/mysqlxx/my.cnf</code>) to obtain:

<pre><code>[mysqld]
# skip-networking
</code></pre>

Of course, stop and start MySQL Server.

blocks|key|4685715|text|如果任何人还在寻找答案，只需检查您的.env文件。由于某些原因，laravel创建了一个.env.example文件，所以所有这些答案对我都不起作用。我修复了将.env.example重命名为.env的问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4685716|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If anyone are still looking for the answer, just check your .env file. For some reason laravel create a .env.example file, so all this answers didn't work for me. I fixed my issue renamming .env.example to .env

blocks|key|4685960|text|这发生在我身上是因为MySQL没有运行。由于缺少/usr/local/etc/my.cnf.d/目录，MySQL无法启动。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4685961|这是我的/usr/local/etc/my.cnf配置文件作为全局包含(include+/usr/local/etc/my.cnf.d/*.cnf)所必需的。|4685962|运行mkdir+/usr/local/etc/my.cnf.d，然后启动MySQL，修复了该问题。|4685963|entityMap^0|O|O|0|4|L|10|11|0|2|T|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|J|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|K|$]]

This happened to me because MySQL wasn't running. MySQL was failing to start because I had a missing <code>/usr/local/etc/my.cnf.d/</code> directory.

This was being required by my <code>/usr/local/etc/my.cnf</code> config file as a glob include (<code>include /usr/local/etc/my.cnf.d/*.cnf</code>).

Running <code>mkdir /usr/local/etc/my.cnf.d</code>, and then starting MySQL, fixed the issue.

blocks|key|179957|text|在我的例子中，我在我的mac终端上运行php+artisan+migrate，当我需要ssh进入流浪者并从那里运行它的时候。希望这能帮助别人解决头痛问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|179958|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In my case, I was running php artisan migrate on my mac terminal, when I needed to ssh into vagrant and run it from there. Hope that helps someone the headache.

blocks|key|4686204|text|在我的例子中，我必须删除bootstrap/cache文件夹，然后再试一次。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4686205|我的cenario是在服务器迁移之后。|4686206|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

In my case I had to remove the bootstrap/cache folder and try it again.

My cenario was after a server migration.

blocks|key|4686336|text|我只在.env文件中做了一处更改|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4686337|我有以下几行代码。|4686338|DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=database_name
DB_USERNAME=root
DB_PASSWORD=|code-block|syntax|javascript|4686339|将主机名localhost更改为127.0.0.1|4686340|DB_CONNECTION=mysql
DB_HOST=127.0.01
DB_PORT=3306
DB_DATABASE=database_name
DB_USERNAME=root
DB_PASSWORD=|4686341|这在我情况下是可行的，因为它找不到任何像localhost这样的主机名|4686342|在更改主机名之后，写入以下命令|4686343|php+artisan+config:clear
php+artisan+migrate:install
php+artisan+migrate|4686344|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|10|8|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|11|8|@]|9|@]|A|$G|H]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

Just i do one change in .env file
I have following line of code.
<pre><code>DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=database_name
DB_USERNAME=root
DB_PASSWORD=
</code></pre>
Change host name localhost to 127.0.0.1
<pre><code>DB_CONNECTION=mysql
DB_HOST=127.0.01
DB_PORT=3306
DB_DATABASE=database_name
DB_USERNAME=root
DB_PASSWORD=
</code></pre>
That is work in my case
because that can't find any hostname like localhost
And after changing hostname write following command
<pre><code>php artisan config:clear
php artisan migrate:install
php artisan migrate
</code></pre>

blocks|key|4686374|text|已解决|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4686375|在我的例子中，这是代码中的逻辑问题，连接值在if语句中：|4686376|if($_SERVER['HTTP_HOST']+==+"localhost")|code-block|syntax|javascript|4686377|因此，解决方案是添加一个管道并添加127.0.0.1，这为我解决了问题|4686378|if($_SERVER['HTTP_HOST']+==+"localhost"+%7C%7C+$_SERVER['HTTP_HOST']+==+"127.0.0.1")|4686379|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Q|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|R|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

solved
in my case it was a logic issue in code, the connection values are in a if statement:
<pre><code>if($_SERVER['HTTP_HOST'] == &quot;localhost&quot;)
</code></pre>
so the solution was to add a pipe and add 127.0.0.1, that solved the problem for me
<pre><code>if($_SERVER['HTTP_HOST'] == &quot;localhost&quot; || $_SERVER['HTTP_HOST'] == &quot;127.0.0.1&quot;)
</code></pre>

blocks|key|4685385|text|在使用VirtualMachine时，请确保通过ssh进入该计算机并导航到您的应用程序文件夹，然后从那里调用php+artisan+migrate命令。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4685386|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

When using a VirtualMachine make sure you ssh into that machine and navigate to your App folder and call the php artisan migrate command from there.

blocks|key|179611|text|在可能的情况下，我简单地使用了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|179612|vagrant+up|code-block|syntax|javascript|179613|而不是|179614|homestead+up|179615|我的伪造幼虫设置用的是宅地。我假设这意味着该站点得到了服务，但MySQL服务器从未启动过。当我使用后一个命令启动我的流浪汉机器时，这个错误就消失了。|179616|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

In may case, I'd simply used 

<pre><code>vagrant up
</code></pre>

instead of 

<pre><code>homestead up
</code></pre>

for my forge larval setup using homestead. I'm assuming this meant the site was getting served, but the MySQL server wasn't ever booted. When I used the latter command to launch my vagrant box, the error went away.

blocks|key|4685865|text|所有这些答案看起来都很繁重……|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4685866|我刚刚创建了一个.env文件；编辑了我的bootstrap/app.php文件，并取消了以下行的注释...|offset|length|style|CODE|4685867|Dotenv::load(__DIR__.'/../');|4685868|希望这能帮助到某人|4685869|entityMap^0|0|8|4|K|H|0|0|T|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]|$D|R|E|S|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@$D|U|E|V|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|W|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|M|$]]

All these answers seem like heavy lifting... 

I just created a <code>.env</code> file; edited my <code>bootstrap/app.php</code> file, and uncommented the following line...

<code>Dotenv::load(__DIR__.'/../');</code>

Hope this helps someone

blocks|key|4686179|text|对于任何人试图创建一个新的数据库连接，不是在laravel上，而是在这里颠簸，寻找答案，从终端运行PDO。这对你会有帮助的。你可以重构它，让它最适合你。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4686180|<?php

class+db
{
+++private+$DBHOST+=+'localhost';+//+you+don't+need+127.0.0.1
+++private+$DRIVER+=+'mysql';
+++private+$PORT+++=+'8888';+//+database+port.+8888+is+mine
+++private+$DB+++++=+'example-db';
+++private+$PASS+++=+'example-pass';
+++private+$USER+++=+'root';
+++private+$SOCKS++=+'';+//+can+fill+this+or+leave+blank.


+++//+-+connect+(dummy+connection)
+++private+function+con()
+++{
+++++++if+($this->SOCKS+==+'')
+++++++{
+++++++++++//+run+shell+command+to+get+
+++++++++++$socks+=+shell_exec('netstat+-ln+%7C+grep+mysql');
+++++++++++$socks+=+trim(substr($socks,+strpos($socks,+'/')));

+++++++++++$this->SOCKS+=+strlen($socks)+>+0+?+';unix_socket='.$socks+:+'';
+++++++}
+++++++else
+++++++{
++++++++++$this->SOCKS+=+';unix_socket='.$this->SOCKS;
+++++++}

+++++++$dsn+=+$this->DRIVER.':host='.$this->DBHOST.';dbname='.$this->DB;

+++++++//+add+socks
+++++++$dsn+.=+$this->SOCKS;

+++++++//+add+port
+++++++$dsn+.=+(strlen($this->PORT)+>+0)+?+';port='.$this->PORT+:+'';

+++++++//+extablish+connection
+++++++$con+=+new+PDO($dsn,+$user,+$pass);

+++++++//+return+PDO+instance.
+++++++return+$con;
+++}
+++//+-+ends+here

+++//+now+you+can+call+$this->con()+within+class+to+use+connection+
+++//+would+run+fine+on+any+terminal

}+|code-block|syntax|javascript|4686181|希望它能帮上忙！|4686182|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

For anyone trying to create a fresh db connection not on laravel but bumped here seeking for answers to run PDO from the Terminal. This would be of help to you. And you can refactor it to work best for you.

<pre><code>&lt;?php

class db
{
 private $DBHOST = 'localhost'; // you don't need 127.0.0.1
 private $DRIVER = 'mysql';
 private $PORT = '8888'; // database port. 8888 is mine
 private $DB = 'example-db';
 private $PASS = 'example-pass';
 private $USER = 'root';
 private $SOCKS = ''; // can fill this or leave blank.


 // - connect (dummy connection)
 private function con()
 {
 if ($this-&gt;SOCKS == '')
 {
 // run shell command to get 
 $socks = shell_exec('netstat -ln | grep mysql');
 $socks = trim(substr($socks, strpos($socks, '/')));

 $this-&gt;SOCKS = strlen($socks) &gt; 0 ? ';unix_socket='.$socks : '';
 }
 else
 {
 $this-&gt;SOCKS = ';unix_socket='.$this-&gt;SOCKS;
 }

 $dsn = $this-&gt;DRIVER.':host='.$this-&gt;DBHOST.';dbname='.$this-&gt;DB;

 // add socks
 $dsn .= $this-&gt;SOCKS;

 // add port
 $dsn .= (strlen($this-&gt;PORT) &gt; 0) ? ';port='.$this-&gt;PORT : '';

 // extablish connection
 $con = new PDO($dsn, $user, $pass);

 // return PDO instance.
 return $con;
 }
 // - ends here

 // now you can call $this-&gt;con() within class to use connection 
 // would run fine on any terminal

} 
</code></pre>

hope it helps!

blocks|key|180161|text|我的回答是针对Laravel的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|180162|在database.php配置文件中创建到本地Docker+MySQL服务的新连接并将其设置为默认连接后，我收到了此消息。我忘记了我是通过在Model中覆盖来设置不同的连接的：|offset|length|style|CODE|180163|class+Model+extends+\Illuminate\Database\Eloquent\Model
{
++++protected+$connection;

++++public+function+__construct(array+$attributes+=+[])
++++{
++++++++parent::__construct($attributes);
++++++++$this->connection+=+'some_other_connection';
++++}
...|code-block|syntax|javascript|180164|因此，即使我在database.php文件中的默认连接指向正确的凭据，模型仍然使用我从本地环境文件中删除的远程数据库连接配置。|180165|entityMap^0|0|1|C|0|0|7|C|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|U|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|V|8|@$D|W|E|X|F|G]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

My answer is specific to Laravel. 

I had this message after creating a new connection in the <code>database.php</code> configuration file to a local Docker MySQL service and setting it as the default connection. I forgot that I was setting a different connection by overwriting it in the Model:

<pre><code>class Model extends \Illuminate\Database\Eloquent\Model
{
 protected $connection;

 public function __construct(array $attributes = [])
 {
 parent::__construct($attributes);
 $this-&gt;connection = 'some_other_connection';
 }
...
</code></pre>

So even if my default connection in the <code>database.php</code> file was pointing to the right credentials, the model was still using the remote database connection configuration which I had removed from the local environment file.

I believe that I've successfully deployed my (very basic) site to fortrabbit, but as soon as I connect to SSH to run some commands (such as <code>php artisan migrate</code> or <code>php artisan db:seed</code>) I get an error message:

<pre><code>[PDOException]
SQLSTATE[HY000] [2002] No such file or directory
</code></pre>

At some point the migration must have worked, because my tables are there - but this doesn't explain why it isn't working for me now.

PDOException SQLSTATE[HY000] [2002] No such file or directory

LAMP堆栈

数据库

服务器

容器

Docker

Drupal

MySQL

我相信我已经成功地将我的(非常基本的)站点部署到fortrabbit，但是一旦我连接到SSH来运行一些命令(例如php artisan migrate或php artisan db:seed)，我就会收到一条错误消息：[PDOException]SQLSTATE[HY000] [2002] No such file or directory在某种程度上，迁移肯定起作用了，因为我的表在那里-但这并不

问PDOException SQLSTATE[HY000] [2002]没有这样的文件或目录
EN

回答 28

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PDOException SQLSTATE[HY000] [2002]没有这样的文件或目录EN

回答 28

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PDOException SQLSTATE[HY000] [2002]没有这样的文件或目录
EN