Magento 2.1.18 is the final 2.1.x release. After June 2019, Magento 2.1.x will no longer receive security patches, quality fixes, or documentation updates.
To maintain your site's performance, security, and PCI compliance, upgrade to the latest version of Magento.

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

Details

During or after installation, a message similar to the following displays:

1
2
Exception' with message 'PHP Fatal error: Uncaught exception 'PDOException' with message 
'SQLSTATE[HY000] [2002] No such file or directory 

Solution

This is commonly caused by a different instance of PHP being used by the PHP command line compared to the web server. In particular, mysql.sock might be misconfigured if this is the case.

To determine whether or not you’re using one instance of PHP:

  1. Log in to your Magento server.
  2. Enter the following command:

    1
    
    php -i | grep 'php.ini'
    

    This determines the settings used by the PHP command-line interface (CLI). Note where php.ini is located.

  3. If you haven’t already done so, set up a phpinfo.php on your web server.
  4. Compare the value of Loaded Configuration File from phpinfo.php with the one from php -i.

    phpinfo.php shows the php.ini file used by your web server. If it’s different from what’s in PHP’s php.ini, you must make all PHP settings consistent for both the PHP CLI and the web server.

    For additional details, consult the documentation provided with your web server.

Updated