Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

PHP Laravel 4 Basics Laravel and Databases Connecting Laravel to MySQL

Ric McCorriston
Ric McCorriston
379 Points

Laravel 5 database.php

On laravel 5 using env - local how do I change the database? It continues to use homestead no matter what database.php says. I know its using this database.php because if I remove it it breaks!

Thanks in advance.

2 Answers

Andrew Shook
Andrew Shook
31,709 Points

First there is a hidden file called .env.example, look around the settings/perferences of your text editor to make sure it will show you hidden files. Next make a copy of that file and simple name it .env. Then open the file and edit it. It should look something like this:

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

from here you can change the settings of the DB. Also, I don't believe you can have more than one .env file anymore. Check out this article for more information

Ric McCorriston
Ric McCorriston
379 Points

Andrew you're a legend. Thank you

Umy Ikem
Umy Ikem
21,383 Points

this gave me some issues - thanks Andrew

Andrew Shook
Andrew Shook
31,709 Points

No problem Umy, glad I could help.