Level 1
Sounds like your database doesn't exist. Have you created the database in MySQL or created the SQLite file?
2 likes
Jul 2, 2015
15
Level 1
Laravel 5 php artisan migrate does not work
Im using Mac os x Yosemite 10.10. I installed the lastest laravel version 5.1. I set up Homestead and it has been running great. However, when I try to make a MySQL connection in my Laravel app, and am now experiencing errors when running php artisan migrate on my development machine. Following is the statement that I see when I run php artisan migrate.
[PDOException] SQLSTATE[HY000] [2002] No such file or directory
How can I solve this problem? When I get into VM, mysql works fine. But I do not know how I can use php artisan migrate. Thank you in advance.
Best
Level 1
Hi. I have made the database that has the same name(users) with my create_users_table.php file. And I also have SQLite file named database.sqlite in storage folder... :(
Level 41
You edited the .env file?
1 like
Level 1
How can I edit .evn file? and What do I need to do with .evn file???
Level 1
As mentioned above, you might need to configure your .env file. To do this, you can simply copy/rename the .env.example to .env and set the appropriate values there.
1 like
Level 41
If you just installed laravel you will see a .env file, rename it to .env and edit these values :
DB_HOST=localhost
DB_DATABASE=database_name
DB_USERNAME=database_username
DB_PASSWORD=database_password
1 like
Level 1
Thank you for the advices. I do appreciate that. But since I'm a beginnier, I can't figure out where .env file is :(
Level 7
.env - It's in your project root.
Once you've done that it may still fail to work.
The error could be that since you are running Homestead as your development environment, you might not have installed MySQL on your actual system..
Try going into your box and trying it.
homestead ssh
cd your/project
php artisan migrate
2 likes
Level 1
I can't find .env file unfortunately.. I'm using Laravel 5.1. Has it been changed? I'm stuck with configuration :( ahhhhhhh
Level 7
Create a file called .env and edit it to suit your needs.
APP_ENV=local
APP_DEBUG=true
APP_KEY=SomeRandomString
DB_HOST=localhost
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=secret
CACHE_DRIVER=file
SESSION_DRIVER=file
QUEUE_DRIVER=sync
MAIL_DRIVER=smtp
MAIL_HOST=mailtrap.io
MAIL_PORT=2525
MAIL_USERNAME=null
MAIL_PASSWORD=null
MAIL_ENCRYPTION=null
1 like
Level 4
.env is not available by default there is a .env.example that you can copy (or rename) with the defaults
1 like
Level 1
Thank for the advices!! I have created .env file as you guys have mentioned. But I still see the same error..
[PDOException]
SQLSTATE[HY000] [2002] No such file or directory
What do I need to do ?????? ahhhh Why does it not work??
Level 6
Seen as you have only now edited your .env file; I'm assuming that you edited the database credentials manually in the database config file. Check to see if you need to revert back to the original env variables.
1 like
Level 1
I have solved my problem by editing databse.php in config folder
'mysql' => [ // ... 'host' => env('DB_HOST', 'localhost') . ('homestead' == gethostname() ? null : ':33060'), // ... ],
This was what I needed. Thank you all. I do appreciate that!
1 like
Level 2
if you are using MAMP then add this>> 'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock',
more details: http://stackoverflow.com/questions/19475762/setting-up-laravel-on-a-mac-php-artisan-migrate-error-no-such-file-or-directory
Please or to participate in this conversation.