dongzheng8463 2016-02-11 10:13
浏览 57
已采纳

Laravel 5:php artisan迁移问题

I have correctly specified the configuration in database.php file.

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

when i run this on console

php artisan migrate

It gives the error Access denied for user 'homestead'@'localhost' (using password: YES)'

Why is it is giving this error and what is the solution?

  • 写回答

2条回答 默认 最新

  • dongwei8440 2016-02-11 10:19
    关注

    In laravel first priority is .env file so that if there is already set a configuration in .env file that will work first,if not found any configuration in .env file then your database.php file will work.In .env file

    DB_HOST=localhost
    DB_DATABASE=database
    DB_USERNAME=root
    DB_PASSWORD=password
    

    If you want to use database.php for configuration then you don't need to use env() function. After removing the env() function the updated code will be

    'mysql' => [
        'driver'    => 'mysql',
        'host'      => 'localhost',
        'database'  => 'laravel5',
        'username'  => 'root',
        'password'  => 'abc123',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ],
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?