Skip to main content

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

Comments

  1. AnonymousJanuary 27, 2015 at 10:15 PM

    this is nice post thanks admin.....
    FULL VERSION SOFTWARE | PORTABLE

    ReplyDelete
  2. raaaaaaat77April 15, 2020 at 9:15 AM

    This comment has been removed by the author.

    ReplyDelete
  3. raaaaaaat77April 15, 2020 at 9:40 AM

    Thanks Anuj!

    ReplyDelete
  4. Jone MarshJuly 23, 2021 at 3:02 AM


    We have offered world-class Law Assignment Help to you as one of the most trustworthy Law Assignment Writing Services. You can improve your grades and wow your professor by seeking help from our expert and native USA Law Assignment help writers. But primarily, let's take a look at how our law assignment writing service might help you.

    ReplyDelete
  5. valueassignmenthelpOctober 27, 2021 at 12:57 AM

    We are leading the best quality assignment help for students with Ph.D. and local academic writers. Value assignment help is the base of services that offer assignments according to your semesters and subjects codes. Find our services in Australia, Germany, Malaysia, U.A.E, India, Canada, South Korea, and the U.S.A. VAH has 2000+ writers in each country to help with your assignment complete before the deadline. Check our exclusive offers at https://valueassignmenthelp.com.
    U.A.E korea assignment help
    Case Study assignment help
    Thesis writing services

    ReplyDelete
  6. zarkazijarDecember 3, 2021 at 3:37 AM

    Great blog, the information shared is very real and special, reflecting correctly and objectively, you have done a great job in sharing, thank you a million times. bui post utme past questions and answers pdf download

    ReplyDelete

Post a Comment

Popular posts from this blog

Create a background / taskbar application in c# .NET

Recently, I was working on integration of two windows applications. First application will launch the second application on login and then they both will communicate using pre-defined set of instructions. There were some complications (I am not going into them) and thus we decided to have a third application which actually will act as mediator. First application will launch the mediator (third application) and it will launch the second application. For this purpose we needed to create a task bar application (which will run in background). How To ·          Create a new windows project and delete the default form (Form1). ·          In Program.cs create a new class and inherit it from Form. ·          Please refer the code below. ·          Now change the Main method. In Application.Run change the startup objec...
2 comments
Read more

Check SQL Server Job status (State) using sp_help_job and xp_sqlagent_enum_jobs

This article is about checking the status of a SQL job. In our work place we have lot of SQL jobs. These jobs will run whole day and are business critical. They will load the data and generate extracts which will be used by business people. Thus, it becomes quite essential to support the system efficiently so that the job finishes in time and as desired. Also, while designing a new system sometimes we need to check the dependency of one job over another. In such scenario we need to check whether a particular job has finished or not. All this can be achieved in SQL Server by using the procedures:- sp_help_job xp_sqlagent_enum_jobs Note: xp_sqlagent_enum_jobs is an undocumented proc inside of sp_help_job and is used extensively to get SQL agent job information. sp_help_job: This procedure gives some insight into the status, and information, about a job. This stored procedure provides information such as last start time, job status etc. Syntax sp_help_job { [ @job_id= ] jo...
2 comments
Read more

Java 8 JMX Default Metrics

This is more of a note. Here you can find default types and attributes for JMX on top of Java 8. Code: I will clean and explain it later :( private static void WriteAttributes(final MBeanServer mBeanServer, final ObjectName http) throws InstanceNotFoundException, IntrospectionException, ReflectionException { MBeanInfo info = mBeanServer.getMBeanInfo(http); MBeanAttributeInfo[] attrInfo = info.getAttributes(); System.out.println("Attributes for object: " + http +":\n"); for (MBeanAttributeInfo attr : attrInfo) { System.out.println(" " + attr.getName() + "\n"); } } Attributes for object: java.lang:type=MemoryPool,name=Metaspace:   Name   Type   Valid   Usage   PeakUsage   MemoryManagerNames   UsageThreshold   UsageThresholdExceeded   UsageThresholdCount   UsageThresholdSupported   CollectionUsageThreshold   Collectio...
Post a Comment
Read more