Laravel database still use old name after .env changed

Question

Edit: php artisan config:cache work nice, but now I got other problem. the URL giving me Error 500

I upload a project to a new subdomain area after I changed .env file when I open URL I still got an error with the old database and user

I tried to check online with the .env file but - I don't know where he stored this database, I tried to see where is this name with ctrl+f but - nothing found

DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=faceterc_hot
DB_USERNAME=faceterc_hot
DB_PASSWORD=testpro

I expect to get the same error maybe but not with the old database name. and this gives me a indicate that maybe the file or something not changed or he using the other details from I don't know where

Welcome. In order to get help you are going to need to improve your question. Please look at this https://stackoverflow.com/help/how-to-ask — ryantxr, May 14 '19 at 22:17
hey i added a picture of the problem. the wired thing is i didnt edited public/index.php — Elroy Cohen, May 14 '19 at 22:40
You may need to build your styles by running `npm run prod` or `npm run dev`. — Peter, May 14 '19 at 22:51
@ElroyCohen Please check if it is having any old values in `config/database.php` — Aditya Thakur, May 14 '19 at 23:36

score 4 · Answer 1 · answered May 15 '19 at 06:54

4

Good, practice for, If you change in a .env file first restart the server using below command.

php artisan serve

then after run below more command for clear old cache and config.

composer dump-autoload
php artisan config:cache
php artisan config:clear

answered May 15 '19 at 06:54

Sujal Patel

2,444
1
19
38

i tried this, now i got :SQLSTATE[HY000] [2002] No such file or directory – Elroy Cohen May 15 '19 at 08:05

Aditya Thakur · Answer 2 · 2019-05-15T05:29:16.010

1

You can simply do a

php artisan config:cache

In case you are on a shared hosting, you can change the values in config/database.php to only use the set values in your .env. Setting it like this will make sure, it only use the .env values.

mysql' => [
'driver'    => 'mysql',
'host'      => env('DB_HOST'),
'database'  => env('DB_DATABASE'),
'username'  => env('DB_USERNAME'),
'password'  => env('DB_PASSWORD'),
'charset'   => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix'    => '',
'strict'    => false, 
],

edited May 15 '19 at 05:29

answered May 14 '19 at 22:52

Aditya Thakur

2,562
2
10
21

hope its more clear now, the problem it's more than that :S – Elroy Cohen May 14 '19 at 23:16
@ElroyCohen Add the user faceterc_hot to the database faceterc_hot – Aditya Thakur May 14 '19 at 23:28
@ElroyCohen can you check you config/database.php file if it is holding any old values? – Aditya Thakur May 14 '19 at 23:32

score 1 · Answer 3 · answered May 15 '19 at 13:37

1

php artisan config:clear Solve the problem with DATABASE error just ran : php artisan config:clear with ssh at the main folder.

answered May 15 '19 at 13:37

Elroy Cohen

41
1
4

score 0 · Answer 4 · answered May 15 '19 at 00:40

0

Just execute

php artisan config:cache

as the laravel cache's the environment files rather than accessing the data from it on every request.

answered May 15 '19 at 00:40

oreopot

3,392
2
19
28

its work i think. but now i got error 500 - The server encountered an internal error or misconfiguration and was unable to complete your request. – Elroy Cohen May 15 '19 at 10:49

score 0 · Answer 5 · answered May 15 '19 at 03:15

0

It's always a good practice to run these couple of commands when you change any environment related variable:

php artisan config:clear
php artisan cache:clear

answered May 15 '19 at 03:15

Deepak Singh

610
1
7
23

César Escudero · Answer 6 · 2019-05-15T00:21:00.490

-1

Execute these commands:

php artisan config:cache
php artisan route:cache
php artisan optimize

That will clear your env cache and it should do.

edited May 15 '19 at 00:21

answered May 14 '19 at 23:59

César Escudero

320
2
12

1

`config:cache` is likely the only thing he needs to do – Casey Anderson May 15 '19 at 00:02

Laravel database still use old name after .env changed

6 Answers6