Laravel XAMPP MySQL artisan migrate install error mysql.sock

In my previous post I wrote about setting up Laravel 4 on Mac with XAMPP. When I tried to use migrations (using artisan) I faced some issue. I will also post about Laravel migrations soon.  

 php artisan migrate:install

Error:                                                 

  [PDOException]                                    

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

Solution:
We need to tell artisan which mysql we want it to use. For this to work we need to porivde it with mysql.sock which we want it to use.

So change your database settings like this:

'mysql' => array(
   'driver'    => 'mysql',
   'host'      => 'localhost',
   'unix_socket' => '/Applications/xampp/xamppfiles/var/mysql/mysql.sock',
   'database'  => 'wedding',
   'username'  => 'root',
   'password'  => '',
   'charset'   => 'utf8',
   'collation' => 'utf8_unicode_ci',
   'prefix'    => '',
  ),

We need to provide "unix_socket".

On mac it will be find at "/Applications/xampp/xamppfiles/var/mysql/mysql.sock" assuming that you have your XAMPP installed correctly in Applications folder.

References:
http://stackoverflow.com/questions/14219692/laravel-setup-of-migrations-using-artisan-is-failing
http://www.jroller.com/jnicho02/entry/setting_up_xampp_on_the