php artisan migrate - SQLSTATE[HY000] [1045] Access denied for user 'laravel'@'localhost'

Question

I want to set up and learn Laravel following this course

When I try to use the command php artisan migrate I get this error:

[Illuminate\Database\QueryException]                                                                                                           SQLSTATE[HY000] [1045] Access denied for user 'laravel'@'localhost' (using password: NO) (SQL: select * from information_schema.tables whe     re table_schema = laravel and table_name = migrations)  [PDOException]                                                                               SQLSTATE[HY000] [1045] Access denied for user 'laravel'@'localhost' (using password: NO) 

I have looked for answers. I figured I may have to make some changes in the .env file, but I don't know what, and nothing I have tried so far has worked.

DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=laravel DB_USERNAME=laravel DB_PASSWORD= 

I'm using Ubuntu 16.04, not a Mac OS X as in the video, so I wonder what should I do differently? Is there some MySQL setting I did not set correctly?

Answer 1

I had the same problem with my plesk ubuntu 18.04 remote server. In your .env file put double quotes around your database password and username then run php artisan config:clear and php artisan cache:clear

DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=dbname DB_USERNAME="xyz"     DB_PASSWORD="123" 

I had never come across this problem before.