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

参数.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

我该如何解决错误?

推荐答案

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

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屋！