Here's the issue

If you're using MAMP, you might have experienced an issue where a website loads just fine in the browser, but when you try to use a Drush command, you get an error like the following:

exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in core/lib/Drupal/Core/Database/Driver/mysql/Connection.php:146

To be completely honest, I'm not sure what causes this issue. I think it has to do with the way Drush accesses MySQL. As far as I can tell, Drush is trying to access the system MySQL, instead of the one that comes with MAMP.

Here's the fix!

Luckily, this can be easily fixed by changing:

'host' => 'localhost',

to

'host' => '127.0.0.1',

and/or by adding the following line to the database credentials in your settings.php (or settings.local.php) file.

'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock',
Example

So, for example, if your database credentials look like this in settings.php:

$databases['default']['default'] = array (<br>&nbsp;&nbsp;'database' =&gt; 'drupal',<br>&nbsp;&nbsp;'username' =&gt; 'root',<br>&nbsp;&nbsp;'password' =&gt; 'root',<br>&nbsp;&nbsp;'prefix' =&gt; '',<br>&nbsp;&nbsp;'host' =&gt; 'localhost',<br>&nbsp;&nbsp;'port' =&gt; '3306',<br>&nbsp;&nbsp;'namespace' =&gt; 'Drupal\\Core\\Database\\Driver\\mysql',<br>&nbsp;&nbsp;'driver' =&gt; 'mysql',<br>);

Change it to this (differences highlighted for clarity):

$databases['default']['default'] = array (<br>&nbsp;&nbsp;'database' =&gt; 'drupal',<br>&nbsp;&nbsp;'username' =&gt; 'root',<br>&nbsp;&nbsp;'password' =&gt; 'root',<br>&nbsp;&nbsp;'prefix' =&gt; '',<br>&nbsp;&nbsp;<span style="color:white;"><strong>'host' =&gt; '127.0.0.1',</strong></span><br>&nbsp;&nbsp;'port' =&gt; '3306',<br>&nbsp;&nbsp;'namespace' =&gt; 'Drupal\\Core\\Database\\Driver\\mysql',<br>&nbsp;&nbsp;'driver' =&gt; 'mysql',<br>&nbsp;&nbsp;<span style="color:white;"><strong>'unix_socket' =&gt; '/Applications/MAMP/tmp/mysql/mysql.sock',</strong></span><br>);

With those updates in the database settings, Drush should work as expected!

Hope that helps!

Tags: DrushMAMPplanet-drupal