Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Why can't I connect to a remote MySQL server from a PHP application, but can connect from mysql-client Question Question
How To Find php.ini? (Ubuntu LAMP on 18.04) Question Question

Question

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

Posted February 3, 2021 3.6k views
MySQLPHPUbuntu 18.04

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

Add a comment
baljinderekrocx
By:
baljinderekrocx

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Why can't I connect to a remote MySQL server from a PHP application, but can connect from mysql-client Question Question
How To Find php.ini? (Ubuntu LAMP on 18.04) Question Question

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.

×
Submit an Answer
2 answers
smadhavapeddi 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

Reply Report
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

Reply Report

Related

Looking for something else?

Ask a new question Search for more help