Home/ Questions/Q 814
Next
Answered
Kenil Vasani
Kenil Vasani

Kenil Vasani

View Profile
  • 7
Asked: 2020-12-18T21:37:46+00:00 In: ,

php artisan migrate – SQLSTATE[HY000] [1045] Access denied for user ‘laravel’@’localhost’

  • 7

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?

laravellaravel-5php
Share

    1 Answer

    1. Kenil Vasani

      Kenil Vasani

      View Profile
      Best Answer

      You don’t have a user named ‘laravel’.
      You should change the DB_USERNAME to the one you’re actually using to access your DB.
      Mostly it’s root by default so the changes in .env should be 

      DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=
      • 4

    You must login to add an answer.