Link to database cannot be established: SQLSTATE[HY000] [2002] No such file or directory

[[email protected]]

Sir, 

 

Prestashop version : 1.6.1.6 

 

On my prestashop  site every thing was going fine.  Suddenly I am seeing this error  :

 

Link to database cannot be established: SQLSTATE[HY000] [2002] No such file or directory

 

I have googled to find a solution for this but could not find.  

 

Pl. help me. 

 

Thanks 

[selectshop.at]

You should ask support from your provider. The error message indicates that a MySQL connection via socket is tried (which is not supported). The socket is not correct or not correct installed, this means localhost or what else (IP) you added as setting for your database  is not found at that location.

 

It could be a wrong setting you are adding (localhost instead of 127.0.0.1, or wrong IP), or mysql has crashed and file is missing. Your provider should read error logs from server and give you and advice or correct the problem.

[MonasLt]

Try to investigate how much free memory the server has. I was keep seeing these errors randomly and it looks like this is related to ram usage. Surprisingly 512MB wasn't enough :/

[Ali Samie]

Thats right. This needs more memory as some tables are pretty heavy in install procedure

[NSN]

@MonasLt@stifler97 I guess that the guy either has solved the problem without giving notice or got bankrupt if his shop could not access the database for 6 years

[Ali Samie]

😅 I hope he is still runnig the business. Anyway, we need to answer questions in community, first to provide solutions and second to prove we are capable of solving problems and get job offers.