Link to database cannot be established: SQLSTATE[HY000] [2002] Connection timed out

[kishoreunni]

Hai everyone 

 

can anyone please tell me what is the error associated with the above message?

 

i passed the prestashop files from local site to remote site using filezilla. And i used openshift for hoisting my site.

 

changed the 

 

'_DB_SERVER_',

'_DB_NAME_',

'_DB_USER_',

'_DB_PASSWD_'

 

inside the settings.inc.php inside config folder.

 

but nothing changes.

 

please help me.

 

Thanks in advance.

Edited March 13, 2015 by kishoreunni (see edit history)

[selectshop.at]

The error message says: the shop cannot connect to your database, it takes to much time for to verify credentials. Seems that credentials are not correct ? You should verify if the credentials of your new database. do correspond to the credentials added to /config/settings.inc.php

[selectshop.at]

DB_server in most of cases is "localhost" or "locasthost:3306" 3306 for the port if special port, or at least it could be also your domain: "your.domain.com". Ask your provider in any case.

[kishoreunni]

when i store _DB_SERVER_ as [email protected]

it shows 

Link to database cannot be established: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known

 

and also when i store xxxxxxxxx-xxx.xx.com

it shows

Link to database cannot be established: SQLSTATE[HY000] [2002] Connection refused

 

when i store localhost or localhost:port no

it shows

Link to database cannot be established: SQLSTATE[HY000] [2002] Connection refused

 

rest of them password,username,and dbname are correct. 

please help me

Edited March 13, 2015 by kishoreunni (see edit history)

[selectshop.at]

You should ask your provider for the correct data to put there. There are several possible methods to connect to database, only your provider knows how he configured his server.

Edited March 13, 2015 by selectshop.at (see edit history)

[joan16v]

I changed "localhost" to "127.0.0.1" and it works!

[kishoreunni]

at last solved thanks every body.

[rmgoncalves]

hello

what did you do to solve? can i do it using putty ?

thank you

[mecollectibles]

It is really very bad that peoples ask questions on how to solve a problem but after they found a way to solve problems, they forget others to give the solution to them too.

Do not be selfish & share what method you found. This is the purpose of this forum too.

[infocapimora]

Buenas me gustaría saber como solucionaron este tema, en mi caso me da el error:

 

Link to database cannot be established: SQLSTATE[HY000] [2002] Connection refused

 

Pero al ir a consultar el fichero setting.inc.php me sale vacio, solo con lo siguiente:

 

<?php

//@deprecated 1.7

 

¿Alguna ayuda plis...?

 

Gracias,

[rocky]

In PrestaShop v1.7, the database settings have moved to app/config/parameters.php, so check the database settings there are correct.

[consolerem]

I'm having suddenly this problem on my website:

Link to database cannot be established: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known

 

Why according to you?

[kdmonk1]

I'm here because I update my php version from php 5 to php56. If you have admin right you can log into root and look for /etc/hosts. This file controls the location of localhost. I opened settings.inc.php and changed this define('_DB_SERVER_', 'localhost:3306'); to reference define('_DB_SERVER_', '127.0.0.1'); and now my website works!

[klemonnier]

QLSTATE[HY000]

I got this error on upgrading my prestashop 1.7.1.1 to 1.7.2.0. I just reset the cache and all works fine

[spaziotecnologia]

I changed "localhost" to "127.0.0.1" and it works!

 

THANKS it worked for me

[TiaNex Shopping]

i changed 127.0.0.1 to localhost 

and then it works ,

for i configured iptables  but there is no rule allow 127.0.0.1

[selectshop.at]

BTW natively "localhost" and "127.0.0.1" is the same thing. The problem is on your server configuration, i.e. server directives or firewall configuration are blocking one of both. So try both: 127.0.0.1 or localhost.

[premsaharan]

for prestashop 1.7.2.4, i moved by code from windows10 to production server, i did all required changes, parameters.php, database table changes like shop_url etc. still i got error while login in to admin panel, database access denied for username root@localhost, this was not even the setting on the server. and website was not accessible.

Only thing worked for me was giving write permission on app/cache folder on the server.