"The only way to make it work is to add the unix_socket line to my Drupal settings.php files for all my projects:"
$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'site',
'username' => 'user',
'password' => 'pass',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
'prefix' => '',
'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock',
),
),
);
this goes into the drush alias:
$aliases['hvdtest'] = array( 'root' => '/Users/james_barnett/Sites/hvdcolladmis/docroot', 'uri' => 'http://hvdcolladmis:8888/', $databases = array ( 'default' => array ( 'default' => array ( 'database' => 'hvdcolladmis_test', 'username' => 'xxxx', 'password' => 'xxxx', 'host' => 'localhost', 'port' => '', 'driver' => 'mysql', 'prefix' => '', 'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock', ), ), ), );
and this goes into the settings.php
$databases = array (
'default' =>
array (
'default' =>
array (
'database' => 'hvdcolladmis_test',
'username' => 'root',
'password' => 'root',
'host' => 'localhost',
'port' => '',
'driver' => 'mysql',
'prefix' => '',
'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock',
),
),
);