Get alerted when assets are down, slow, or vulnerable to SSL attacks—all free for a month. Learn more

Question

SQLSTATE[HY000] [2002] No such file or directory

SQLSTATE[HY000] [2002] No such file or directory: This error keeps poping up. I have installed magento 2.3.5 version Please let me know how to fix this error

Thanks

Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

KFSys • February 3, 2021

Hi @baljinderekrocx,

You’ll most probably have to change the hostname from localhost to 127.0.0.1 in the env configuration file of your Magento application.

First, go to your Website’s DocumentRoot

cd /path/to/website

Once inside open the config file

nano app/etc/env.php

In there you’ll find an enviroment called host, change it like so

change 'host' => 'localhost' to 'host' =>'127.0.0.1'

Save the file and reload the website to see if the error is still being experienced.

Regards, KFSys

Sri Charan Madhavapeddi • February 3, 2021

Hello,

Once, can you check if the MySQL service is up and running. If it is down, you will need to restart.

service mysql start

You also may have to change the hostname from localhost to 127.0.0.1 in env configuration file in your magento root directory

Open app/etc/env.php
change 'host' => 'localhost' to 'host' =>'127.0.0.1'
Save file and retry

Keep us posted, if this worked.

Cheers, Sri Charan

Try DigitalOcean for free

Click below to sign up and get $100 of credit to try our products over 60 days!

Sign up