SQLSTATE[HY000] [2003] Can't connect to MySQL server on

问题描述

我在 Laravel 4.1(使用 MAMP)的本地主机上收到以下错误

I am receiving the following error on my localhost for Laravel 4.1 (using MAMP)

SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (61)

它指向:

/Applications/MAMP/htdocs/crowdsets/laravel-master/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php

这是它指向的函数:

public function createConnection($dsn, array $config, array $options)
    {
        $username = array_get($config, 'username');

        $password = array_get($config, 'password');

        return new PDO($dsn, $username, $password, $options);
    }

到目前为止，我还没有收到此错误.

Up to this point, I had not received this error.

我设置了本地环境和生产环境(默认).

I have a local environment and production environment set up (the default).

在 config/local/database.php 我有:

in config/local/database.php I have:

'mysql' => array(
            'driver'    => 'mysql',
            'host'      => '127.0.0.1',
            'database'  => 'database',
            'username'  => 'root',
            'password'  => 'root',
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),

推荐答案

这样的错误意味着服务器本身甚至无法访问.您是否在 MAMP 中启动了 MySQL?

An error like that means the server itself is not even reachable. Did you start MySQL in MAMP?

另外，您是如何开始 MAMP 的?使用标准 MySQL 3306 端口?或者 MAMP 用于非管理员的替代端口:8889?

Also, how have you started MAMP? With the standard MySQL 3306 port? Or the alternative port MAMP uses for non-admins: 8889?

我打赌您的服务器正在运行，但正在尝试连接到 3306，因此您需要将端口设置为 8889.将您的配置更改为这样；注意添加 port 参数:

I bet your server is running, but is attempting to connect to 3306 so you need to set the port to 8889. Change your config to be like this; note the addition of the port param:

'mysql' => array(
            'driver'    => 'mysql',
            'host'      => '127.0.0.1',
            'port'      => '8889',
            'database'  => 'database',
            'username'  => 'root',
            'password'  => 'root',
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
        ),

我刚刚发现 this question thread 解决了通过端口 8889 将 Laravel 连接到 MAMP 的问题.

I just found this question thread that addresses the issue of connecting Laravel to MAMP via port 8889.

这篇关于SQLSTATE[HY000] [2003] Can't connect to MySQL server on '127.0.0.1' (61) error Laravel 4.1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！