Fix for : Access denied for user ‘homestead’@’localhost’
You are here because you are working on a Laravel Project and on Opening of the project web page you see this error.
[Illuminate\Database\QueryException] SQLSTATE[HY000] [1045] Access denied for user 'homestead'@'localhost' (using password: YES) (SQL: select * from information_schema.tables where table_schema = homestead and table_name = migrations) [PDOException] SQLSTATE[HY000] [1045] Access denied for user 'homestead'@'localhost' (using password: YES)
The solution to this error is pretty simple. You have a .env file in your project. The .env file contains different property variables which applies to your project environment.
This include database connection properties, Application key value , SMTP Details etc.
In the default .env file the database settings are set to something like this
DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=homestead DB_USERNAME=homestead DB_PASSWORD=secret
You need to change the DB_DATABASE , DB_USERNAME, DB_PASSWORD as per your local mysql settings in the .env file of your project
Once you correct these property variables in .env file, you should be able to access your application page.
If you have already changed the database property variables in .env file and you are still not able to access your project.
Follow these two additional steps.
Open your terminal , Go to the project root directory and execute this artisan command.
php artisan config:clear
Restart your Apache server and refresh the page. You no longer see the Error.