Symfony 2 SQLSTATE [HY000] [2002]连接拒绝错误 [英] Symfony 2 SQLSTATE[HY000] [2002] Connection refused Error
本文介绍了Symfony 2 SQLSTATE [HY000] [2002]连接拒绝错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SQLSTATE [HY000] [2002]连接拒绝
parameters.yml
参数:
database_driver:pdo_mysql
database_host:127.0.0.1
database_port:'8889'
数据库名称:symfony
database_user:root
database_password:root
mailer_transport:smtp
mailer_host:127.0.0.1
mailer_user:null
mailer_password:null
语言环境:tr
秘密: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。
查看完整配置示例:
#学说配置
doctrine:
dbal:
default_connection:默认
连接:
默认值:
驱动程序:%database_driver%
dbname:%database_name%
用户:%database_user%
主机:%database_host%
密码:%database_password%
unix_socket:/tmp/mysql.sock
I get an error like database operations using Symfony2.
SQLSTATE[HY000] [2002] Connection refused
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
And console:
Kemal-Karakass-MacBook-Pro:~ kemalkarakas$ locate mysql.sock
/private/var/mysql/mysql.sock
How do I resolve the error?
解决方案
There is a parameter unix_socket you can use within your config.yml.
See full configuration example:
# 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屋!
查看全文