'PDOException' with message 'SQLSTATE[HY000] [2002] zend framework

Question

Any one plz tell me why i am getting this error ?? firstly my internet connection was good today its not good so i am getting this error.how can i fix this any idea plz??

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] A 
connection attempt failed because the connected party did not properly respond after a 

period of time, or established connection failed because connected host has failed to
respond. ' in D:\SVN 
data\WebClient_PHP\trunk\p\library\Zend\Db\Adapter\Pdo\Abstract.php:129 

Stack trace: #0 D:\SVN     
data\WebClient_PHP\trunk\p\library\Zend\Db\Adapter\Pdo\Abstract.php(129):  
PDO->__construct('mysql:host=192....', 'root', 'root', Array) #1 D:\SVN   
data\WebClient_PHP\trunk\p\library\Zend\Db\Adapter\Pdo\Mysql.php(109): 
Zend_Db_Adapter_Pdo_Abstract->_connect() #2 D:\SVN  
data\WebClient_PHP\trunk\p\library\Zend\Db\Adapter\Abstract.php(860):  
Zend_Db_Adapter_Pdo_Mysql->_connect() #3 D:\SVN  
data\WebClient_PHP\trunk\p\library\Zend\Db\Adapter\Abstract.php(930):  
Zend_Db_Adapter_Abstract->quote('testing', NULL) #4 D:\SVN 
data\WebClient_PHP\trunk\p\library\Zend\Auth\Adapter\DbTable.php(449): Zen 
in D:\SVN 
data\WebClient_PHP\trunk\p\library\Zend\Db\Adapter\Pdo\Abstract.php on line 
144

this is my config.ini

[general]
db.adapter = PDO_MYSQL
db.params.host = 192.168.0.233
db.params.username = root
db.params.password = my_password
db.params.dbname = "mydatabasename"

some code from my index.php

$config = new Zend_Config_Ini(ROOT_DIR.'/application/config.ini', 'general');
$DB = Zend_Db::factory($config->db);
Zend_Db_Table::setDefaultAdapter($DB);

It looks as if your script cannot connec to the mysql server. Did you check the mysql web site to see what those error codes mean? — vascowhite
– vascowhite, Commented Mar 13, 2012 at 11:02

Fawad Ghafoor · Accepted Answer · 2012-03-14 06:19:43Z

8

it seems that your code this portion is not working

[general]
 db.adapter = PDO_MYSQL
 db.params.host = 192.168.0.233
 db.params.username = root
 db.params.password = my_password
 db.params.dbname = "mydatabasename"

either the IP is not correct if so go to cmd in windows and type ipconfig you will get your correct ip paste it here OR just simply write

 db.params.host = localhost

if and only if you are using locally may be it works.

answered Mar 14, 2012 at 6:19

Fawad Ghafoor

6,2377 gold badges43 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marek Sebera · Accepted Answer · 2014-02-12 14:06:31Z

3

for the hostname/host try to use your credentials found in the Zend Server -> PHP Cloud tab -> Overview page -> User Parameters tab... then make the "host" part in the credentials like this:

[general]
 db.adapter = PDO_MYSQL
 db.params.host = CONTAINERNAME-db.my.phpcloud.com
 db.params.username = ZEND_DB_USERNAME
 db.params.password = ZEND_DB_USERNAME
 db.params.dbname = ZEND_DB_DBNAME

edited Feb 12, 2014 at 14:06

Marek Sebera

40.8k37 gold badges166 silver badges252 bronze badges

answered Dec 11, 2013 at 5:44

Frederick G. Sandalo

92910 silver badges24 bronze badges

1 Comment

Frederick G. Sandalo Over a year ago

hi Marek Sebara, what changes did you add to my answer? I cannot identify them other than the "newline" characters. It says "24 characters are added", but I dont see them

arraintxo · Accepted Answer · 2012-03-13 11:39:52Z

0

Did you check your mysql database is up?

If you are sure it is, check that your adapters configuration is ok, maybe the host parameter is not properly configured.

answered Mar 13, 2012 at 11:39

arraintxo

4842 silver badges12 bronze badges

2 Comments

Edward Maya Over a year ago

how to know that mysql is up ?? both apache and my sql are running.i am editing my question so that u see some more code

arraintxo Over a year ago

try connecting to mysql through command line "mysql.exe -uroot -p -h 192.168.0.233" or you can try with "telnet 192.168.0.233 3306" if you don't have mysql installed on your host.

Collectives™ on Stack Overflow

'PDOException' with message 'SQLSTATE[HY000] [2002] zend framework

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related