Symfony 2 SQLSTATE [HY000] [2002] 连接被拒绝错误 [英] Symfony 2 SQLSTATE[HY000] [2002] Connection refused Error

问题描述

我收到一个错误，比如使用 Symfony2 进行数据库操作.

I get an error like database operations using Symfony2.

SQLSTATE[HY000] [2002] Connection refused

parameters.yml

parameters.yml

parameters:
  database_driver: pdo_mysql
  database_host: 127.0.0.1
  database_port: '8889'
  database_name: symfony
  database_user: root
  database_password: root
  mailer_transport: smtp
  mailer_host: 127.0.0.1
  mailer_user: null
  mailer_password: null
  locale: tr
  secret: ef9b4381fe75208f060b7c786951242bebcfb3c2
  database_path: /private/var/mysql/mysql.sock

和控制台:

Kemal-Karakass-MacBook-Pro:~ kemalkarakas$ locate mysql.sock
/private/var/mysql/mysql.sock

我该如何解决这个错误?

How do I resolve the error?

推荐答案

您可以在 config.yml 中使用一个参数 unix_socket.

There is a parameter unix_socket you can use within your config.yml.

查看完整的配置示例:

# Doctrine Configuration
doctrine:
    dbal:
        default_connection: default
        connections:
            default:
                driver:   %database_driver%
                dbname:   %database_name%
                user:     %database_user%
                host:     %database_host%
                password: %database_password%
                unix_socket: /tmp/mysql.sock

这篇关于Symfony 2 SQLSTATE [HY000] [2002] 连接被拒绝错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！